Re: MySQL to Oracle Migration

From: Ankit Thakwani <>
Date: Mon, 22 Dec 2014 16:16:52 +0530
Message-ID: <>


I once did a POC of MySQL 5.5.12 to Oracle 11gR2 data migration using Tungsten Replicator - you can consider it Open Source Golden Gate: (, it migrates the table structure but you will have to manually create Procedures, Referential Constraints, Indexes and Sequences on Oracle Side.

They have a pretty active google group where you can ask for help :!forum/tungsten-replicator-discuss

Also they have uploaded very informative webinars on same topic:


On Wed, Dec 17, 2014 at 10:07 PM, Alex Nunes <> wrote:

> 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

Thanks and Regards
Ankit Thakwani

Received on Mon Dec 22 2014 - 11:46:52 CET

Original text of this message