Instructions on Automatic Generation of databases by powerdesigner

Reverse Engineering: generates a PD data model from the MySQL database.

(Environment: powderdesigner15.0; mysql5.1)

1. the ODBC Data Source of MySQL must be configured first.

Configure a MySQL data source in the control panel data source (ODBC), first go to the official website to download MySQL ODBC ctor (such as my below is: mysql-connector-odbc-5.1.5-win32.msi), install. You can see the MySQL driver in the data source configuration. configure a MySQL data source according to the data source configuration steps.

2. Open powerdesigner. Select File ---> reverse engineer ---> Database

A. Fill in your modelname in the pop-up dialog box new physic data model, select DBMS as mysql5, and click OK.

B. In the pop-up database reverse engineer options, select using a data source and click Connect to a data source to bring up the connect to a data source dialog box.

Select "Data Source" as ODBC machine data source, enter the user password for the MySQL data source you Just configured, and click "Connect" to return to database reverse engineer options, and click "OK.

C. The database reverse engineer dialog box is displayed. Select the table to be generated and click OK.

Automatically generate database instructions

Method 1:

Use powerdesigner to export the PDM (Physical Data Model) graph from an existing database, analyze the PDM graph by using another tool pdmreader (which can be downloaded from http://www.pdmreader.com/), and then generate instructions.

1. After generating a PDM image, open it with pdmreader. Note that when opening a PDM image with pdmreader, make sure that the image is not opened in powerdesigner.
2. Click Create project. In the displayed dialog box, enter the project name and click OK;
3. Select the project name, click "Import Data Dictionary", select the generated PDM chart, and click "open;
4. Select the PDM graph Link under the project name. A link named "Export dictionary to Doc" will appear on the right. Click here.

Method 2:

Pdmreader can directly export data dictionaries from the database, which is more convenient than importing data from the database to PDM and then reading data with pdmreader. The table remarks can also be obtained.
However, this function provides the best support for Oracle, followed by SQL Server and access database.

Click the button above the main interface:
"Import Data Dictionary"-> "I have no PDM, and I use pdmreader to import data directly from the Database"
You can.