PowerDesigner importing data to MySQL

Each time before it was straight up to build the table, after the completion of the discovery of logical a lot of errors, but also does not well represent the relationship between table and table. Although previously also used PowerDesigner, but with the use of the database is separate, that is, when beginners used PD, and then no longer used. Today due to a relatively large project, I have considered a long time or the first use of Visio and PD to clarify the relationship between the data, in the process of my use of PD, I suddenly remembered that PD seems to be directly to the MySQL conversion, and then I Baidu a bit, and finally used a one-hour successful solution. Take this essay to make a note, but also give some directions to other beginners:

I. ODBC driver for MySQL installation

1, official website download http://dev.mysql.com/downloads/connector/odbc/5.1.html

If the system is 64-bit, to download and install the 32-bit, 64-bit installation package

If only 64 bits are installed, the 32 bits in the C:\Windows\SysWOW64\odbcad32.exe C drive will be automatically run, and the error is displayed:

2. Configure the ODBC driver connection:

Control Panel, Administrative Tools->ODBC data source (32-bit), double-click

Click Add

Click Finish

Click Test, if the display is successful, click OK;

Second, PowerDesigner connection database

1, build table, conceptual model, logical model, physical model

2. Database->connect to a Data Source

Click Modify, select Data source

Click ok-> Click Connect

Third, PowerDesigner to the database conversion (reverse generation)

Database->generate database gets:

Click OK to get the SQL statement:

Copy the SQL statement to MySQL and execute the line.

PowerDesigner importing data to MySQL