Re: MySQL to Oracle Migration
- From: Ankit Thakwani <ankit.thakwani@xxxxxxxxx>
- To: alex.nunes.xmn@xxxxxxxxx
- Date: Mon, 22 Dec 2014 16:16:52 +0530
Hi,
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@xxxxxxxxx>
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
Other related posts:
