How to convert an Oracle SQL file to a MySQL SQL file

Source: Internet
Author: User
Tags powerdesigner

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.