Powerdesigner reverse MySQL 5.1 database generation ERTU

Source: Internet
Author: User
Tags powerdesigner


The powerdesigner I used is version 15.1 and the database is MySQL5.1.57.
(1) create a "PhysicalDataModel" file, and then click "Database"-> "Configure Connections". The "Configure Data Connections" window appears ", and select "Connection Profiles", as shown in: www.2cto.com (2) to create a mysql Connection, as shown in the following window:
Enter the connection information, as shown in. (note the following when entering the relevant information: <1> User name: And Password: the username and Password of the mysql database; <2> JDBC driver jar files: the location of your mysql-connector-java-5.1.13-bin.jar, click the icon to select .) Www.2cto.com. after entering the relevant information, click "Test Connection" in the lower left corner ..." To test whether the connection is successful.
If the connection is successful, the following window is displayed when you click "OK. If the connection is not successful, you need to configure the mysql-connector-java-5.1.13-bin.jar environment variables, the process is as follows: (5) after the connection is successful, click "Database"-> "Update Model from Database (shortcut: CTRL_R) ", the pop-up window" Database Reverse Engineering Options "is displayed, as shown in: Click to configure connections, as shown in: After completing the configuration, the following window is displayed: www.2cto.com select the database or some tables in the database for reverse engineering, and click "OK" to complete reverse engineering operations on the database. (Note: by default, all databases are selected. Therefore, before selecting a database that requires reverse engineering, click "cancel all" to make all databases unselected .)
So far, the connection environment of the reverse engineering of powerdesigner has been fully configured. You only need to select the database or table for reverse engineering and click "OK" to export the PhysicalDataModel diagram of the data.
Author woisnong

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.