PowerDesigner Reverse Engineering/forward engineering operation steps

PowerDesigner Reverse engineering Operation steps

(The data structure is built, the model is generated).

1. Open "PowerDesigner"

2. Create a new blank physical data model

Click the PowerDesigner menu bar "File" ==> "New" to select "Physicaldatamodel" on the left. In model name, enter the name of the new model, select the database type in the DBMS, and click OK to complete the new.

3. Data source for new database

Take SQLServer2005 as an example, open the Control Panel ==> Administrative Tools ==> data Sources (ODBC) ==> Select the System DNS tab ==> Click the Add button and select the driver for which you want to install the data source. > Click the "Finish" button, enter the data source "name", select the server ==> click "Next" button, remove the "change the default database to" option ==> click "Next" until completion ==> click "Test Data Source" button to "test successfully!" ”。

4. Reverse engineering operation

Click the PowerDesigner menu bar "File" ==> "Database" ==> "Reverse Engineer database" ==> Select "Selecttion a Data" in the "useing" tab Source ", click on the Small Data icon (Connect to a data source) ==> Select" ODBC machine Data Source "in the dropdown box to select the data source ==> all the way, go to" Database Reverse Engineering "form, select Database ==> click" OK "to finish! (Of course, it's easier to reverse-engineer a SQL statement, which is no longer discussed here.)

The following error is reported when using PowerDesigner12 to reverse engineer an ODBC connection SQL2005:

---------------------------
Powerdesigner-error
---------------------------
Unable to list the tables.

[Microsoft] [ODBC SQL Server Driver] [SQL Server] failed to prepare the statement.

SQLSTATE = 37000

The approach is as follows:

1, when establishing ODBC, "change the default database as" This option to remove the execution

2, select the database in the new interface (note: It is the Engineering interface in database Reverse instead of the database Reverse Engineering options interface).

PowerDesigner Forward Engineering Operation steps

(Completed data model, generate data structure)

1. Open "Microsoft SQL Server" (described here as an example of this database).

2. Create a new empty database on the target database server.

3. Open a well-designed data model with PowerDesigner.

4, click on the menu bar "database" ==> "Generate database ...".

5, PowerDesigner forward Engineering

Method one: The SQL statement is forward to the engineering step.

1. On the "Database Generation" form that pops up in the fourth step, select the "General" tab.

2. Click the folder icon after "Directory", select the SQL statement export location, enter the file name of the SQL file in "file name", and click "Script Generation" radio button in "Generation type".

3. Click OK, the SQL script file is generated successfully. can be run directly.

Method Two: The data source forward engineering step.

1. Create a new data source for the new database in the second step.

2. On the "Database Generation" form that pops up in the fourth step, select the "General" tab.

3. Click the folder icon after "Directory", select the SQL statement export location, enter the file name of the SQL file in "file name", and click the "Direct Generation" radio button in "Generation type". Select the first step to create a new data source and enter the user name and password for the database.

4. Click OK to eject the Execute SQL Query window and click the Run button. PowerDesigner Tip "Statement successfully executed." Click on the "Close" button in the "Execute SQL Query" Window PowerDesigner "Generation successful".

PowerDesigner Reverse Engineering/forward engineering operation steps