Saturday, June 20, 2015

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:

image

Start Migration by Clicking MySQLMigrationTool.exe

 

ScreenHunter_215 Jun. 19 23.39

ScreenHunter_216 Jun. 19 23.39

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

ScreenHunter_217 Jun. 19 23.39ScreenHunter_218 Jun. 19 23.39ScreenHunter_219 Jun. 19 23.39

ScreenHunter_220 Jun. 19 23.39

Select Schema to migrate

ScreenHunter_221 Jun. 19 23.40ScreenHunter_224 Jun. 19 23.40ScreenHunter_225 Jun. 19 23.40ScreenHunter_226 Jun. 19 23.41ScreenHunter_227 Jun. 19 23.41ScreenHunter_228 Jun. 19 23.41ScreenHunter_229 Jun. 19 23.41ScreenHunter_230 Jun. 19 23.42

ScreenHunter_231 Jun. 19 23.42

Schema Creation

ScreenHunter_234 Jun. 19 23.42ScreenHunter_236 Jun. 19 23.43

Transfer the data

ScreenHunter_237 Jun. 19 23.43ScreenHunter_238 Jun. 19 23.43ScreenHunter_239 Jun. 19 23.43ScreenHunter_240 Jun. 19 23.43

Verify the data

ScreenHunter_241 Jun. 19 23.45ScreenHunter_242 Jun. 19 23.45