Use powerdesigner 15 to reverse engineer existing databases (Graphic tutorial 1) by yulh

Source: Internet
Author: User
Tags powerdesigner

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.