How to import SQL Server database and powerdesignersql in PowerDesigner

How to import SQL Server database and powerdesignersql in PowerDesigner

After using PD to create a table, compile it into an SQL script and run it in SQL Server to generate a database. Can I directly generate a PD document for the database? After going online, you can certainly.

To import a database in SQL Server to PD, you must first establish a database link and then perform reverse engineering operations. Next, start the operation.

Step 1: Open the database menu and select "Configure Connections"

Step 2: Create a New ODBC Link

Step 3: Select a System Data Source

Step 4: Select the required database

Step 5: "Complete"

Step 6: Name the data source and select the server

Step 7: Select the login method and the data login name and password

Step 8: Test connection

Step 9: After creating the Database link, select "file-Reverse Engineer -- Database"

Step 10: Set "Model name" and the database to be connected

Step 2: Select a data source

Step 2: Select the database and table to import

Step 2: Import completed

Summary:

At this point, importing the database in SQL Server to PD is complete. In addition to sighing the power of PD, it is also essential that PD wholeheartedly serve the people. It is important not to do what we want, but to do what we want!

Through the introduction of the above content, we hope to help you understand how to import databases to PD.