Re: Migration from Oracle TO MySQL

Thank you,

WGB From: Uwe Küchler <uwe_at_kuechler.org> To: oracle-l digest users <oracle-l_at_freelists.org> Date: 03/19/2013 10:34 AM

Subject:        Migration from Oracle TO MySQL
Sent by:        oracle-l-bounce_at_freelists.org

Dear oracle-l'ers,

has anyone ever gone down the road of migrating an Oracle DB to MySQL? I have this challenge currently, because a customer wants to migrate to a software solution that runs on MySQL only.

The number of hits for a Google search is immense, but most of the stuff goes either in the other (usual) direction or just gives some commonplace suggestions.

Even if this won't be solved here, I thought that my research so far could be of interest to others. So here's what I've done and found out so far:

• MySQL Workbench is the usual tool of choice for migrations from other database systems to MySQL. On mysql.com, some pages mention migrations from Oracle, but most of them don't (there's just MS SQL, Sybase, PostgreSQL and "Generic" ODBC sources). If you try to use the migration wizard of MySQL Workbench (as of 5.2.47), it stops with an ODBC error. In the MySQL bug database, there's a more or less "official" answer from Oracle: "Apologies but Migration from Oracle DBs is not supported". (http://bugs.mysql.com/bug.php?idf609 )
• It looks as if the previous tool "MySQL Migration Toolkit" was able to do that (and used JDBC instead of ODBC). Has anyone ever tried this successfully?
• Then I considered DBVisit and similar replication tools as a means of migrating data. On their homepage, it sounds like a replication from scratch was possible. But a further look into the documentation revealed, that both systems had to be "in sync" before replication could start. I suppose this isn't different with Golden Gate, although I haven't double-checked that.
• DBconvert (DMSoft Technologies) takes like forever before it finally freezes completely.
• Intelligent Converters wasn't even able to retrieve a list of schemas and/or tables (and we're talking about some 150 tables only).
• Not tried yet: Spectral Core Full Convert ( http://www.spectralcore.com/fullconvert/tutorials/convert-oracle-to-mysql.php ). Looks promising, but that happened before... any experiences?

So, this is the status quo. I suspected that Oracle isn't very interested in providing tools to migrate away from their core product, but it strikes me that there aren't many other proven solutions around.

Cheers,
Uwe

--
http://oraculix.com/

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




Although this e-mail and any attachments are believed to be free of any virus or other defect which might affect any computer system, it is the responsibility of the recipient to check that it is virus-free and the sender accepts no responsibility or liability for any loss, injury, damage, cost or expense arising in any way from receipt or use thereof by the recipient.

The information contained in this electronic mail message is confidential information and intended only for the use of the individual or entity named above, and may be privileged.  If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.  If you have received this transmission in error, please  contact the sender immediately, delete this material from your computer and destroy all related paper media.  Please note that the documents transmitted are not intended to be binding until a hard copy has been manually signed by all parties.
Thank you.
--
http://www.freelists.org/webpage/oracle-l