Re: Migration from Oracle TO MySQL
- From: Kellyn Pot'vin <kellyn.potvin@xxxxxxxxx>
- To: "uwe@xxxxxxxxxxxx" <uwe@xxxxxxxxxxxx>, oracle-l digest users <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Mar 2013 09:00:01 -0700 (PDT)
My last company did migrate a major web facing Oracle DB to MySQL. The
application collected views and clicks, etc. from the web and Oracle simply had
too much "required redundancy" in it to guarantee ACID that MySQL ended up
being the answer. No tool was used to migrate to the new environment. The
database was redesigned and then enhanced to a sharded MySQL server farm that
required the DBA, who was primary on the project, to update/rewrite most of the
code to be compliant with MySQL. A wonderful MySQL DBA was hired at the end of
the project and he implemented partitioning, along with other enhancements,
creating a simple, but robust MySQL database environment that, per a
conversation just last month, is still humming along like a champ! Nothing was
wrong with Oracle, it just wasn't the right tool for this job.
I only *slightly* remember discussions on migration tools, but those were
thrown out pretty early on in the project and so much of the work from that
company was done with proprietary code, so I'm not surprised.
Kellyn Pot'Vin
Senior Technical Consultant
Enkitec
DBAKevlar.com
RMOUG Director of Training Days 2013
~Tombez sept fois, se relever huit!
________________________________
From: Uwe Küchler <uwe@xxxxxxxxxxxx>
To: oracle-l digest users <oracle-l@xxxxxxxxxxxxx>
Sent: Tuesday, March 19, 2013 9:33 AM
Subject: Migration from Oracle TO MySQL
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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
