- Green versionCheck
- Green versionCheck
- Green versionCheck
- Green versionCheck
PowerDesigner features
【DataArchitect】
This is a powerful database design tool. Using DataArchitect, you can use the entity-relationship diagram to create a "conceptual data model" - CDM (Conceptual Data Model) for an information system. In addition, DataArchitect can also reversely generate PDM, CDM and SQL scripts for creating databases based on existing databases.
【ProcessAnalyst】
This part is used to create functional models and data flow diagrams, and create "processing hierarchical relationships".
【AppModeler】
Create application models for client/server applications.
【ODBCAdministrator】
This part is used to manage various data sources of the system.
PowerDesigner installation method
1. Download the PowerDesigner program from this site and run it, select Next> in the red circle:
2. Select the installation area and then select the agreement to agree to the agreement, as shown in the figure below. Click Next to proceed:
3. Select the installation location of PowerDesigner: By default, it is installed in the C drive directory. You can click the browse button behind the path to customize the software installation location. After confirming the installation location, click Next> to continue:
4. Select the components to be installed. You can check this according to your own needs. In order to better experience the powerdesigner software, the editor recommends checking them all. Then click Next>:
5. Select the user profile that needs to be installed. Here we can still choose the default settings. Click Next> to continue:
6. Then you can click Next on the interface starting here, confirm the installation information and click Install.
7. Wait for the installation to complete and you will see the following picture. Click finish to exit the installation wizard.
How to use PowerDesigner
How to create a table in PowerDesigner? How does PowerDesigner generate sql statements?
1. Start the PowerDesigner software we have installed and enter the main interface. The first step is to create the model. Only after the model is established can the table be created for subsequent operations. For specific operations, click "File" and select "New Model", and then a dialog box will pop up. Enter the model name in "Model name" on the page, and select the database type you want to generate in "DBMS". The editor suggests that after selecting it here, it will be easier to generate statements in the future.
2. Create the model based on the above, and then start building the table. First, select the table creation tool in the right toolbar. Click the table in "Physical Diagram" in the left toolbox to create it. Click and select the placement location in the middle.
3. The editor chose to place it in the middle, and then started adding fields. Double-click to modify the table name.
4. Create table fields. Among them, Name is the table name to be used in the query, Code is the field name, and comment is the description of the table field.
5.Date Type is the type of the set field, where varchar(40) is a string type and int is a numeric type. Length is the length of the field. If it is a primary key, Piamary and Mandatory must be selected. One indicates the primary key, and the other indicates that it cannot be empty.
6. Now that the basic table creation is complete, right-click on the table name and select "SQL Preview" to see the SQL code.
PowerDesigner FAQ
How does PowerDesigner design the association between tables?
1. Open PowerDesigner and find the icon as shown below in the toolbox. This icon represents the Reference Relationship tool.
2. Establish a reference relationship. The arrow points to the parent table. Double-click the reference relationship line to open the relationship properties box.
3. After opening, please check whether the parent table and child table are correct. If you want to modify them, please click the drop-down list box to reselect, click the connection label, and then set the associated fields. The editor recommends that you try not to use the name generated by the system by default, and please modify it manually.
How does PowerDesigner export SQL?
1. First open the powerdesigner software we have installed. Then open a project.
2. Click "database" and select the "Change Current DBMS" option in the drop-down menu to modify the script type. There are many mainstream databases such as mysql, sql server/oracle, and db2 for everyone to choose from. You can choose one according to your needs. Can.
3. The editor chooses mysql5.0 to continue explaining to you. Files can be renamed in the box below. Just click OK.
4. Then click "Database" on the toolbar again, and select the "Generate Database" option in the drop-down menu.
5. Set the script saving path and definition name. Click OK after the settings are completed.
6. Wait for export and find it in the save path to use it. At the same time, the console log information in the powerdesigner software will also be prompted. Click edit to directly open the file for editing.
PowerDesigner updates
Optimized some functions
Baidu SkydiskExtraction code: rj9q
Huajun editor recommends:
PowerDesigner is a free software with wide application and powerful functions. The functions of this new version have been highly praised by many netizens. It is strongly recommended that everyone download and use it. In addition, there areSQL Server automatic installer,Data Loader,SQLyog,DBF Commander,DBeaverIt is recommended for everyone to download and use.
it works
it works
it works