PowerDesigner Connect to SQL Server

I've heard of it before. PowerDesigner can be connected to a database, creating tables, triggers, and stored procedures into a database based on the data model created in PowerDesigner. You can also export an existing database to PowerDesigner as the data model. Today did a test, found that it is really simple, now the operation of the steps to share with you:
0. Preparatory work
First create a database in SQL Server for testing purposes.
Create Database Test
1. Create tables, triggers, stored procedures into the database according to the data model created in PowerDesigner
1) Open PowerDesigner to create a physical data model


2) Leave the default settings in the dialog box that pops up


3) Rename the newly created physical data model to test

4) in which two tables are built, creating an association relationship of two tables.


5) Click "Database", "Configure Connections"


6) in the ODBC data Source Manager that pops up, click "Add" to add a data source


















As you can see, a SQL Server data source named test has been successfully added.

7. Click "Database", "Connect:" To connect to the data source you just added.



8) Click "Database", "Generate database" to create a table




In the dialog box above, you can choose the directory and file name of the generated script, there are many options below, and I keep the default options. Note Check "script generation" to generate only scripts, and select "ODBC generation" to prompt you to execute the script to the database.

Click Run to run the script, or you can manually modify the script and then run.run it, then to view the database and discover that the association between the table and the table has been created.

2. Export the existing database to PowerDesigner for the data model

1) Create a new physical data model named Test2

2) Click "Database", "Connect ..." Connect to the data source.



3) Click "Database", "Reverse Engineer database ..."

4) Using an ODBC data source

5) Click "OK", you can see the following dialog box, the meaning of the option is also very clear, by default, only the export table is selected:


6) "OK" after you can see the import scroll bar, when finished, you can see that the database table has been imported into the data model.

PowerDesigner Connect to SQL Server