Oracle data migration to MySQL

First of all make sure your Oracle and MySQL connection is no problem, my oracle10g and mysql5.2, tool is mysql-gui-tools-5.0-r17-win32.msi called MySQL migration tookit

Then install this MySQL migration tookit, is http://dev.mysql.com/downloads/gui-tools/5.0.html, according to your local environment download, I downloaded the Windows version installed successfully after the software opened, this name is called: MySQL mi ration tookit.

After opening the software, the first two steps do not have to direct next to the source Database, when using this MySQL mi ration tookit, it will let you add a JDBC driver

1. Click: Locate Driver on harddisk associated with your Oracle driver package, after successful it will prompt to restart, then you restart, repeat the first two steps, Next,next, and then you will see such an interface,

This step we have to note that the software itself has a driver, but this we can not use, we want to use our own added driver, two drivers you will see the name has a using, this is what we introduced, choose it

2. After the driver selection is successful, look down (or this page)

Explain: Stored Connection: This name is free to write.

Service: This is the database name.

Hostname: The address of the database, for example, if I want to connect with someone else on the LAN, I will write 192.168.1.110 directly.

Username: User Name

Password: Password

When these are written, click Next.

3. The previous step is configured with the library you want to export, this step is configured to import the library

Explanation: This step configuration needs to import the library, the import is MySQL, the driver has been added to you, the key is the following

Stored connection This name is the same as the Stored connection that exported the library *

Hostname:mysql address, here is the emphasis, if you are the local best to write localhost, will be reported error

Username: User Name

Password:mima

Configure, click Next

4. This step is to check your import library and export the library address, user name, password, whether it is correct, click Next, if you make a mistake, please click on the button below to see the error message, to respond to the correction

5. Select the library you want to export in Oracle, select the library, click Next

6. Go to reverse engineering reverse engineering source database, all successful, click Next

7. Go to Object Type Selection, here We click Detailed selection>> button, to select the table we want to export, the left is to export, the right is not exported, note

When you're done choosing, click Next

8. Go to Object Mapping, where the migration of type Oracle schema is our Oracle database, click on the set parameter inside for setting parameters, a total of three options

We are using UTF-8 encoding, database is also, we choose this second option here, if the data sheet is GBK, then you choose the third option, and fill in Addautoincrement=yes, CHARSET=GBK, Collation=gbk_ General_ci, Engine=innodb,

Fill in the previous step and click Next to continue

9. Go to migration, then click Next to continue

10. Go to Manual Editing, this step is very important, here to modify the script, in the filter we select "Show all Objects" all the tables, and then click on the "advanced>>" button to make changes to the selected table

After successful modification, click on Apply changes save, each table is modified successfully, click Next

11. Go to the object Creation Options and if you want to see the SQL statement, tick the Create Script File for Create statments and click Next

12. Go to createing Objects and click Next

13. Go to Createion Results and click Next

If there's next, click Next, until it appears.

This is a successful migration from Oracle to MySQL.

If used please indicate source: http://www.cnblogs.com/duwenlei/

Oracle data migration to MySQL