MySQL to Oracle Migration

  • From: Alex Nunes <alex.nunes.xmn@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 17 Dec 2014 08:37:34 -0800

Greetings Oracle-L,

I am seeking your expert advice (ideas and/or proven solutions as well as
any pitfalls) on ways to migrate data from MySQL (v. 5.6.19) to Oracle 11g
R2. The data volume in question here is around 25gb (small) but there are
160 tables that needs to be migrated to Oracle.
Business can afford to take an outage for this migration.
So far I came up with this initial list:

1) GoldenGate: seems an overkill for me.
2) SQL Developer
3) Oracle Workbench Migration
4) Export -> flat files / Sql*Loader

Thanks in advance for any info on this.

Alex Nunes

Other related posts: