With its powerful database design functions and the ability to generate database scripts or databases for the designed model, Power Design (PD) is widely used in software development. However, when there is only one existing database and there is no database design document, it is often confusing. So here we will talk about how to use PD to reverse engineer the database, SQL Server does not know other databases?
Step 1: create a data source for the database for reverse engineering. On the Control Panel> Administrative Tools> data source (ODBC), select the system DSN tab and click the Add button to create a data source according to the wizard. Here I name it pdtest.
Step 2: Open PD. In the files menu, select database... in reverse engineer. The following dialog box is displayed:
Select SQL Server 2000 from the DBMS in the general option carari and click OK. The following dialog box is displayed,
Select using an odbs data sourse, select the data source we just created, and click OK. If the database connection is correct at this time, all user tables in the database should be displayed,
Select the data table for reverse engineering and click "OK". At this time, PD starts to generate the physical model. We can generate the expected Conceptual Model Based on this physical model. this completes the reverse engineering process using PD.