How to import SQL Server databases in PowerDesigner _mssql2005

After using PD to build the table, and then after the SQL script is run in SQL Server and then build the database, think of it, can you directly generate the contents of the database PD document? After the internet search, of course.

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.

The first step : Open the Database menu, select "Configure Connections"

Step Two : Create a new ODBC link

Step three : Select the system data source

Step Fourth : Select the database you want

Fifth Step : "Complete"

Step Sixth : Name the data source and select the server

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

Step Eighth : Test the connection

nineth Step : After establishing the database link, select "File-reverse engineer--database"

Step Tenth : Set the Model name and the database to which you want to connect

Step 11th : Select a data source

Step 12th : Select the database and table to import

13th Step : Import complete

Summarize:

Here, importing the database from SQL Server into PD is complete. In addition to lament the strong PD, but also inseparable from the heart of PD for the people's purpose ah, not what we want to do, but want what we have, this is very important!

Through the introduction of the above content, I hope that we can master the method of database import to PD help.