Methods for importing SQL files into PowerDesigner (convert Oracle SQL files to MySQL)
The method of importing the database structure of the Xxxxxx.sql file into PowerDesigner is as follows: First step: The table structure of all tables of the library to be imported (no table data, as long as the table structure) is exported as a. sql file.
Step two: Find File >> Reverse Engineer >> Database in Powerdesinger, as
Figure one, select "Share the DBMS definition" and click OK. Note that the database should also be selected and its own SQL database corresponding to, my database is oracle11g, all I also chose oracle11g. Make sure to appear as www.2cto.com figure two, select "Using script Files", click the Add button on the bottom side, add the Xxx.sql file, and then choose OK!!! Convert to MySQL applicable database
OK, the SQL statements you just imported from Oracle are now mysql5.0.
Press the shortcut key ctrl+g export MySQL SQL file, shortcut key, pop up "Database Generation" window interface, the file name to modify the exported filename, my is Jm.sql
Transferred from: http://www.2cto.com/database/201210/161178.html
How to convert an Oracle SQL file to a MySQL SQL file