For MySQL Migration Toolkit 1.0 issues encountered in migrating Oracle to MySQL

Here is the main point I encountered in the application of the problem, the main process reference http://www.cnblogs.com/duwenlei/p/3520759.html.

Start MySQLMigrationTool.exe "initialized Java loader" error first, such as

I discovered it because my JDK was 64 bits, and the tool needed 32 bits, and then a 32-bit JDK, and I installed 1.7, if I didn't want to change the environment variable start reference http://javabyraj.blogspot.com/2013/09/ Solution-for-initialized-java-loader.html, the main content is to go through the command line to the root of the tool and then execute a command:

Step 1:open the command prompt. Change to the MySQL Tools installation path (path would be vary based on the installed MySQL version) C:\Documents and SETTINGS\SYSTEM14>CD C:\Program files\mysql\mysql Tools for 5.0Step 2:and then type the following command (Jvm.dll path would be a vary based on the installed Java version) C:\Program files\mysql\mysql Tools for 5.0>mysqlmigrationtool-verbose -JVM "C:\Program files\java\jre7\bin\client\jvm.dll"The Java loader initialized successfully.

This starts the problem resolution.

Next choose the data source service, I choose Oracle, then need to load OJDBC, there are two buttons below, usually choose to load from the hard disk,

If add fails

Then copy the jar package directly to the \java\lib in the tool root directory and restart the tool to take effect.

Error when connecting to an Oracle server, such as

There are two kinds of reasons: 1. Database connection parameters may be wrong, IP, database name, user name, password what 2.ojdbc. jar Package version problem, my server oracle11g, jar package is OJDBC6, usually use OJDBC package in development environment is no problem.

These are the problems and solutions that are encountered in using Mysqlmigrationtool to migrate databases from Oracle to MySQL, and ultimately succeed!

For MySQL Migration Toolkit 1.0 issues encountered in migrating Oracle to MySQL