Re: MySQL to Oracle Migration

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: ( http://docs.continuent.com/tungsten-replicator-3.0/deployment-hetero.html), 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 : https://groups.google.com/forum/#!forum/tungsten-replicator-discuss

Also they have uploaded very informative webinars on same topic: https://www.youtube.com/user/v1rsun3n

Regards,
Ankit

On Wed, Dec 17, 2014 at 10:07 PM, Alex Nunes <alex.nunes.xmn_at_gmail.com> 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

--
http://www.freelists.org/webpage/oracle-l