Reverse-Generate MySQL data dictionary using PowerDesigner and Pdmreader

The following mentioned software everyone can search on the Internet, or through QQ 121088825 find me, I send you.

1th step: Download an ODBC data source connection first, note that 32-bit system installs 32-bit software, 64-bit system installs 64-bit software.

Mysql-connector-odbc-5.1.5-win32.rar

Mysql-connector-odbc-5.1.7-winx64.rar

Install the steps and precautions that everyone can find on the Internet. Using ODBC is nothing more than configuring the MySQL connection string, user name and password.

Related software Download:

The 2nd step: Download PowerDesigner software, according to the relevant needs to crack and Chinese.

This step on the internet also has a lot of examples, here also do not repeat.

Below we use PowerDesigner to reverse generate PDM files.

Menu "File" "Reverse engineering" "Database", select MySQL 5.0 in the Model Name drop-down list.

Wait a while, and we'll see the relationship between the database table and the table you've chosen.

Then we click on the menu "file" "Save as" to save to the. pdm file. After the preservation of the relationship, of course, if you forget, there is no relationship, the operation of the following software will have a corresponding hint.

3rd Step: Use Pdmreader software.

Create a new project (in fact, there is a project by default), and then import the data dictionary, this button is very easy to find, I can not. Then select Import *.PDM file from PowerDesigner.

I generally choose to "export the dictionary to HTML", done.

Finally, let's talk about the precautions for these operations, some of which have been repeated above.

(1) The installation of MYSQL-CONNECTOR-ODBC software should choose the same number of digits as the operating system, otherwise the installation will be unsuccessful;

(2) The version of PowerDesigner and Pdmreader software should correspond. As a result of my testing, the latest version of Pdmreader is supported only to PowerDesigner version 12.5, and the exported *.PDM file for 15 is not supported.

Of course, if you do not notice the author of these Pdmreader software will also give you a very thoughtful hint, also will give you PowerDesigner 12 version of the download link;

(3) Use PowerDesigner export *.PDM have a select the database and select the table operation, here must first the default all the database, all the data table before the tick off, otherwise it will generate a lot of tables, interfering with us, this specific operation has been mentioned above.

(4) Pdmreader is best to use the latest version, in the Pdmreader this software "help" menu, will help you to download to the latest version.

I used a random version, found that the generated. html file links can not jump, or very uncomfortable.

Basically introduced here, welcome you to make more valuable comments.

Resources:

PowerDesigner reverse automatic generation of MySQL documentation _ Baidu Experience
Http://jingyan.baidu.com/article/e2284b2b5a90e4e2e6118d07.html

Reverse-Generate MySQL data dictionary using PowerDesigner and Pdmreader