Import the database in SQL Server to the PowerDesigner and powerdesigner databases.

Import the database in SQL Server to the PowerDesigner and powerdesigner databases.

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 the 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 the connection

Step 9: after creating a 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!

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.