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.