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: