The Project Experience Small collection (4) ___sql Server reverse engineering, import the database into the PowerDesigner

PD is a good database design tool, at first, the partner with PD roughly designed 10 tables, we in the project development directly using forward engineering, the PD design database directly into SQL Server can be created database and table structure, with the development of the project, We have changed the table structure and number of tables, in order to ensure the consistency of the database and PD graph, here we use reverse engineering, the database into PD, Oracle, SQL Server and other databases, can be reverse engineering to import the database into PD. SQL Server reverse engineering, the first need to establish a database connection, and then reverse engineering operations. The following is a brief introduction to the steps of "reverse engineering SQL SERVER2008R2, importing a database into PowerDesigner15":

I. Building a PDM file

Open pd,file→new Model→model types→physical Data model→physical Diagram.

Two. Establish the PD connection to the database

2.1 Open the "DataBase" menu and select "Configure Connections ..."

2.2 Popup "Configure Data Connections" window

2.3 Selecting a system data source

2.4 Select the database you need

2.5 make the database address settings and SA account settings

2.6 Click Finish to test the connection

At this point, the ODBC connection to the database SQL SERVER R2 is established.

Three. Reverse engineering import a database into PD

3.1 After establishing the database connection, select File→reverser engineer→database

3.2 Click OK to eject

3.3 Click Connect, select the tables, views, and Table objects, general stored procedures, etc. to import

At this point, the reverse engineering of SQL Server is over, and here is a partial PD graph generated by reverse engineering: