Common modeling tools are: PowerDesigner and Erwin, which are quickly eliminated, but the former is still active. I believe that we have met the project team has been operating for a long time, but even an ER diagram is not, today to explain the PowerDesigner connection MySQL reverse generation PDM. PS: Various old versions on the network, all kinds of irrelevant, according to this article to do, 10 minutes can be done, it is so simple.
Assume that everyone has installed PowerDesigner, I use version number 15.1 cracked Chinese version.
1. Install Mysql-connector-odbc-5.1.5-win32.msi This is the driver must be installed, about 4M, Baidu Search can be.
2. Open PowerDesigner, document-"reverse engineer--" Database model name Customization-"
Select the DBMS for MySQL 5.0--"Using a data source Select a DataSource click on the red circle in the graph, click Configure,
Click on the red circle to add a new data source. , next select the first step to install the driver, next, OK.
, fill in the relevant data, the above two lines to write casually, the following 4 lines are the necessary fields to connect the database. Click OK, jump to the drop-down box to select the data source you just configured, click Connect,
, click OK to filter the table to be exported (<all users> drop-down filter)--"OK to generate PDM."
Note: If the PDM requires a comment (comment), then the MySQL must be filled in beforehand.
Done ~
PowerDesigner connection MySQL Reverse generation PDM