Generate an erdiagram using the reverse database structure of powerdesigner

It is said that programmers like to use powerDesign for database modeling. Generally, the physical model diagram is designed first, and the SQL statements required by the database are converted to generate the database. However, the legend of "powerDesign reverse engineering" is circulating in the rivers and lakes. Well, today we will use PowerDesign to build reverse engineering. Data Based on MySql5.0

It is said that programmers like to use powerDesign for database modeling. Generally, the physical model diagram is designed first, and the SQL statements required by the database are converted to generate the database. However, the legend of "powerDesign reverse engineering" is circulating in the rivers and lakes. Well, today we will use PowerDesign to build reverse engineering. Data Based on MySql 5.0

It is said that programmers like to use powerDesign for database modeling. Generally, the physical model diagram is designed first, and the SQL statements required by the database are converted to generate the database.
However, the legend of "powerDesign reverse engineering" is circulating in the rivers and lakes. Well, today we will use PowerDesign to build reverse engineering.

Based on MySql 5.0 database, PowerDesigner12. mainly divided into these steps.

1> Create an ODBC data source through windows Data Source Management.

• First, install the ODBC patch.
• Here is the patch files for mySql 3.5.1 and mySql5.1.5. Use them for installation.

• Open Windows Control Panel
• Open management tools

• Open Data Source (ODBC)

• Select the database type you want to operate on

• Enter database parameters and test the connection

2> use the ODBC data source through powerDesigner to create a data source for PowerDesigner.

• Create a physical model.

• Select DataBase> Connect ).

• Select the configured ODBC data source.

• Enter the user name and password for logging on to the database ].

2> Use PowerDesigner for reverse engineering.

• Select DataBase ---- Reverse Engineer Database.

• Use the configured data source.

• Select the content you are interested in.

• Generate a physical model.

• We waited for a moment and I came up with the data model we needed. For example:

• After amplification

Here, our reverse engineering is complete.

I also collected some blog posts related to powerdesign:

Power Designer encountered sqlstate = 37000 http://hi.baidu.com/laurel_2010/blog/item/c1ba715314327013367abeb8.html for the second reverse connection

Changing column name and Code Synchronization in PowerDesigner

Http://blog.sina.com.cn/s/blog_4a096c410100azp9.html