Import a database from SQL Server into the PowerDesigner

After using the PD to build the table and then generate the SQL script and then run it in SQL Server after the database is built, it is possible to generate a PD document directly from the contents of the database. After surfing the internet, of course you can.

To import a database from SQL Server into PD, you first need to establish a link to the database and then reverse-engineer the operation. Start the operation below.

First step: Open the Database menu and select "Configure Connections"

Step Two: Create a new ODBC link
Step Three: Select the system data source
Fourth Step: Select the desired database
Fifth step: "Done"
Sixth Step: Name the data source and select the server


Seventh Step: Choose Login mode, and data login name and password


Eighth step: test the connection

Nineth Step: After establishing a good database link, select "File-reverse engineer--database"

Tenth step: Set "Model name" and the database to be connected
11th Step: Select a data source



12th Step: Select the databases and tables to import

13th Step: Import Complete
Summary:

Here, the database in SQL Server is imported into PD even if it is done. In addition to the strong sigh of PD, but also inseparable from PD's dedication for the people's purpose ah, not want what we do, but want what we have, this is very important!

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Import a database from SQL Server into the PowerDesigner