How to import a table from a database into PowerDesigner

Source: Internet
Author: User
Tags microsoft sql server 2005 odbc powerdesigner

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

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.