Because an early project was not output as a E-R chart when the database design was established, the PD was used for reverse engineering of the original database during the secondary transformation and upgrade of the project, that is, all tables in the database are generated into a E-R graph structure based on the data source. I am using PD 15, and the reverse engineering command is "reverse engineer"-Reverse engine in the File menu. The PD of other versions should be in the "Database" menu. The detailed steps are as follows:
1. Start PD
2. Menu: database-> congfigure connections the congfigure data connections dialog box is displayed.
Click Add data source. The create data source dialog box is displayed:
Select "System Data Source". Next step:
Data source driverProgramSelect SQL Server and proceed to the next step:
Click "finish" to bring up the new data source created to SQL Server. In this dialog box, enter the name, description, and server name or IP Address:
Next: Verify the login method, select "use SQL Server verification with user input Login ID and password", and enter the login ID and Password
Next: Change the default database and you want to reverse the work process
Next step: complete
Finally, the new data source will appear in the congfigure data connections dialog box.
The next article describes how to reverse work based on the created data, that is, to generate a E-R diagram.
To be continued ......
By yulh