Using “MySQL Migration Toolkit” to migrate from Oracle to MySQL

Prepare software (these are discontinued/obsoleted software)

http://downloads.mysql.com/archives/migration/

http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase5-419410.html

Install the JDK5, extract MT tools into a folder, and copy jdbc drivers into it’s java folder:

Start Migration by Clicking MySQLMigrationTool.exe

 

Select source and target database (Oracle 12c and MySQL 5.6 used in this example)

Select Schema to migrate

Schema Creation

Transfer the data

Verify the data