RE: MySQL to Oracle Migration

From: Nisha Riyaj <ariyajah_at_uci.edu>
Date: Wed, 17 Dec 2014 18:14:07 +0000
Message-ID: <BLUPR06MB675999B7D24474789A16B59DE6D0_at_BLUPR06MB675.namprd06.prod.outlook.com>

I migrated MySql database to Oracle 11g last month using Sql Developer. It’s very easy and simple.

Followed this Oracle note and used Sql developer to copy tables from MySql to Oracle database. Database size was 3GB.

http://www.oracle.com/technetwork/database/migration/connect-step-mysql-1946352.html

One thing to remember is to make sure the data type conversion is set correctly otherwise it will convert binary data type in MySql to LOB type in Oracle and it will cause errors during conversion.

[cid:image001.png_at_01D019E2.301F8620]

--nisha

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jeff Smith Sent: Wednesday, December 17, 2014 10:04 AM To: alex.nunes.xmn_at_gmail.com; oracle-l_at_freelists.org Subject: RE: MySQL to Oracle Migration

One advantage of using SQL Developer, other than it being free, is that when you migrate your objects, it creates a data model first. If a column or table name is changed based on an incompatible identifier - maybe it's too long or contains a keyword - that propagates to the rest of the model.

There are many other advantages...

25gb you could probably get away with doing an online migration, but I'd do the offline one. It will unload your data to SQL*Loader files that you can upload at your convenience to your new Oracle schema.

Oracle Workbench Migration is deprecated - all that it WAS, is now SQL Developer. Unless you're moving Informix.

Jeff

From: Alex Nunes [mailto:alex.nunes.xmn_at_gmail.com]

Sent: Wednesday, December 17, 2014 11:38 AM

To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>

Subject: MySQL to Oracle Migration

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

--

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

--

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

Received on Wed Dec 17 2014 - 19:14:07 CET