MySQL Forums
Forum List  »  Oracle

Re: how to convert oracle to mysql
Posted by: richard dawson
Date: June 05, 2012 03:44AM

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 preferrably, 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.

Options: ReplyQuote

Written By
November 23, 2010 04:30AM
June 15, 2011 12:10AM
November 10, 2011 01:52AM
August 30, 2011 11:36PM
February 12, 2011 11:11AM
March 16, 2011 12:44PM
March 05, 2012 02:49PM
August 23, 2011 03:27AM
Re: how to convert oracle to mysql
June 05, 2012 03:44AM
August 05, 2011 10:32AM
December 02, 2011 10:28AM
January 06, 2012 09:37AM
February 03, 2012 08:37AM
August 30, 2012 07:20AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.