Use powerdesigner to generate an SQL script and reverse engineering to generate an erdiagram

1. Press Ctrl + G in powerdesigner to enter the generate database interface. Select your table and the generated SQL file path name. 2. There are two methods: generate a script, one is to connect to the target database through ODBC to generate a table. 3. if you select generate a script, you can get an SQL file named after you. 4. If you want to connect to the target database to generate a table through ODBC, you must first define the ODBC link. 5. We recommend that you use the SQL script generation method.

 

 

 

I,SQL issue generated by powerdesigner
The SQL generation method is database --> Generate database (CTRL + G), but the prompt is displayed.

Cocould not load VBScript engine.
Check VBScript installation.

Generation aborted due to errors detected during the verification of the model.

 

After checking for a long time, I found that I can remove the check model! Where,

Whether one file on needs to generate multiple SQL statements according to the table (optional by default, that is, not required)
ODBC generation SQL is directly generated into the database
Automatic archive generates an SQL statement and generates an APM file at the same time.

Check Model

Powerdesigner defines the maximum length of table names, field names, and other names of each database. This length is used by powerdesigner as the check model, however, the length of this definition is not necessarily the same as the actual allowed length of the database. If you want to pass the PD check, you can modify the settings in the PD. (The PD conventions for different databases are actually saved in an XML file with the extension. XDB )! Or you can choose not to check the model when generating the database.

It is estimated that the default name length provided by PD is less than the allowed length of the database, which is a naming convention. The name should not be too long.

 

Ii. Power Designer: reverse engineering to generate an erdiagram
1. in powerdesigner, choose file | reverse engineer | database .... the new physical data model dialog box, shown next, appears. choose Oracle 10 Gb for the DBMS and click "OK"
2. in the database reverse engineering window, click "using script files" and then click the "new" icon. A file selection dialog box is displayed, and the script file location is selected. then press "OK ".
3. Generate er digoal