1, open PowerDesigner12, in the menu according to the following way to operate File->reverse Engineer->database
When clicked, the New Physical Data Model dialog box pops up, such as:
2. in the General tab
Model name: The template name, named by itself.
Dmbms: As needed, I chose Microsoft SQL Server 2005
Click OK to eject the Database Reverse engineeringoption dialog box
3. Selection tab, check the Using a Data source option
Note that if you are importing data for the first time, you will need to prepare your own ODBC data source first, by doing the following:
1) Click the Database Connection button on the right below to eject the ConnectTo a Data Source dialog box
2) Select the ODBC machine Data source option and click the Configure button on the right of the Modify button to eject Configure data Connections
4 . Click the Second Database Configuration button (AddData source (CTRL + N)) in the toolbar below the ODBC Machine Data Sources tab to create a new Data Source window, select the file data source, select the appropriate data source driver Program (I choose SQL Server), click Next, give the data source a name, select the server, next, enter the appropriate password
How to import a table from a database into PowerDesigner