Use PowerDesigner 15 to reverse engineer existing databases and powerdesigner15

Source: Internet
Author: User
Tags powerdesigner

Use PowerDesigner 15 to reverse engineer existing databases and powerdesigner15

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:

Select SQL Server as the data source driver 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.


A E-R graph is generated based on the created data source.

1. Start PD

2. Menu: File> Reverse Engineer> Database New Physical Data Model dialog box

Click "OK" to bring up the Database Reverse Engineering Options dialog box:

Select Using a data source, click the Data Source button to bring up the Connection to a data source dialog box, select the Data Source we created earlier from the drop-down box, and enter the User ID and password

Click Connection to connect to the database and retrieve all database objects. Here we select all tables.

Click OK !!, See the following section:


Related Article

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.