How to derive the physical Model of MySQL Database from PowerDesiner 15 reverse Engineering

This article will explain in detail how to derive the physical model of MySQL database from PowerDesiner 15 reverse engineering. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

To connect to the Percona version 5.6 database, you need to install ODBC first. PowerDesiner's machine is 64-bit, and previously installed version 5.1 32-bit ODBC, which makes it impossible to add data sources for MySQL.

ODBC version 5. 1 64-bit is installed, but the error "the setup routines for MySQL ODBC 5. 1 driver could not be loaded.." is reported when connecting to the database.

You need to download version 5.3 64-bit ODBC at the following address:

Http://dev.mysql.com/downloads/connector/odbc/

After installing version 5.3 of ODBC, you need to go to the management tools of the control panel first, click ODBC, add the data source of MySQL, fill in the IP and port of MySQL, and the user name and password do not need to be configured. When you connect with PowerDesigner, you can enter it.

Then use reverse engineering to connect to the database

Connect using the MySQL data source you created earlier

It should be noted that when exporting data objects such as tables, you need to select the exported data objects, otherwise all tables and other data objects that can be queried under user permissions will be exported by default.

Cancel all tables before selecting the tables under the specified database.

About PowerDesiner 15 reverse engineering how to export MySQL database physical model is shared here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.