How to import data tables in SQL Server to PowerDesigner

This article describes how to import the data table structure designed in SQL Server to PowerDesigner.

I use SQL Server 2005 and PowerDesigner15.1. First, enable Powerdesigner15.1, as shown in,

Double-click PowerDesigner to open the software.
Create a project and click File. For example,

Select New Projet. The following dialog box is displayed.

In the dialog box above, enter the Project Name (MY Name IS Pro_Test ), in Location, select the project storage Location (under the Test folder of drive D), and click OK. If there is no Test folder under drive D, the following dialog box is displayed. Click Yes to create the project.

After the project is created, the project we just created appears in the Workspace, as shown in.

Next we will create a physical data model.

Select the project you just created, click New, and then click Physical Data Model. The following dialog box is displayed.

Select physicaldimodel and select the data name (Test_PhysicalModel) in the Model name. For DBMS, select SQL Server 2005 (because I use SQL Server 2005) and click OK. Under Pro_Test, there is the physical data model we just created.

After the physical data model is created, we can import the data table structure in the database to our physical data model.

Click File, select Recerse Engineer, and click Database. The following dialog box is displayed.

In the DBMS, select SQL Server2005 and click OK. The following dialog box is displayed.

This dialog box is used to connect to the data source. Select ODBC machine data source and click Configure to bring up the following dialog box.

This dialog box is used to select the import method. The first Using script files mode does not need to be connected to the database. You only need to select an SQL script file. We do not use this mode today, instead, import data from the data source. Click the button in the red line to pop up the following dialog box.

This dialog box is used to create a data source, which is displayed in the list after creation. Click the button in the red line to bring up the following dialog box.

Select the user data source and click Next.

Select SQL Server and click Next

Click Finish. Next, create a new data source.

Enter the data source name and the server (if it is a local machine, it can be represented ). Click Next.

Select to use the user to enter the login ID for verification, and then enter the user name and password. Next step

Select the database to be imported. Next step

In this way, the data source is created, and the data source we just created is displayed in the list.

Click OK.

Test passed.

Let's go back to the settings and select the new data source. OK.

Select the expected table and click OK.

Next, return to the "connect data source" dialog box and select the data source red line you just created. Enter the user name and password, and click Connect.
The data table is successfully imported, as shown in.