MySQL to Oracle Migration

From: Alex Nunes <alex.nunes.xmn_at_gmail.com>
Date: Wed, 17 Dec 2014 08:37:34 -0800
Message-ID: <CAFYphvac7KNDcXUF52=wfWpDJtn5o=ipHBik6fyFGFiALC7Ayg_at_mail.gmail.com>

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:

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

Thanks in advance for any info on this.

Alex Nunes

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

Received on Wed Dec 17 2014 - 17:37:34 CET

This message: [ Message body ]
Next message: Anthony Ballo: "RE: SQL: Listing the dates for a particular day of the week in a range"
Previous message: Jeremy Schneider: "Re: Questions on ASM best practices"
Next in thread: Jeff Smith: "RE: MySQL to Oracle Migration"
Reply: Jeff Smith: "RE: MySQL to Oracle Migration"
Reply: Ankit Thakwani: "Re: MySQL to Oracle Migration"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message