Migrate from Oracle to MySQL
Posted
by Cassy
on Stack Overflow
See other posts from Stack Overflow
or by Cassy
Published on 2010-03-19T17:59:51Z
Indexed on
2010/03/19
18:01 UTC
Read the original article
Hit count: 148
Hi together.
We ran into serious performance problems with our Oracle database and we would like to try to migrate to a MySQL-based database (either MySQL directly or, more preferrable, Infobright).
The thing is, we need to let the old and the new system overlap for at least some weeks if not months, before we actually know, if all features of the new database match our needs.
So, here is our situation:
The Oracle database consists of multiple tables with each millions of rows. During the day, there are literally thousands of statements, which we cannot stop for migration.
Every morning, new data is imported into the Oracle database, replacing some thousands of rows. Copying this process is not a problem, so we could, in theory, import in both databases in parallel.
But, and here lies the challenge, for this to work, we need to have an export from the Oracle database with a consistent state from one day. (We cannot export some tables on Monday and some others on Tuesday, etc.) This means, that at least the export should be finished in less than one day.
Our first thought was to dump the schema, but I wasn't able to find a tool to import an Oracle dump file into mysql. Exporting tables in CSV files might work, but I'm afraid it could take too long.
So my question now is: What should I do? Is there any tool to import Oracle dump files into MySQL? Does anybody have any experience with such a large-scale migration?
Thanks in advance,
Cassy
PS: Please, don't suggest performance optimization techniques for Oracle, we already tried a lot :-)
© Stack Overflow or respective owner