MySQL Forums
Forum List  »  Oracle

Smart solution for mapping of data migration Oracle to MySQL
Posted by: molo molo
Date: January 25, 2007 08:58AM

Hello, Everybody

First of all want to say what I read many forums and topics. But I have not very trivial task...

Could you please tell me some yours suggestions about process of data migration form Oracle to MySQL database.

The main problem is we don't have the same tables in that databases (some table from Oracle come in couple tables in MySQL, some data from columns come in couple columns and must to have some logical parsing before)

The finally structure of MySQL DB is don't ready yet - it's mean what it can change many times even during a day/week. So I need some interactive tool and have ability to configurate of type mapping, names tables, columns and so on. Maybe through prorerties/ini files, XML...

I understand it's might consists couple tools, some/many coding, parsing, diffent technologies ...

Process must be automatic so GUI tools is useless

Oracle: couple GB
MySQL: v. 5.0.xx
OS: Windows XP
Human resource: oracle, java developer

Look forword for any ideas...


Options: ReplyQuote

Written By
Smart solution for mapping of data migration Oracle to MySQL
January 25, 2007 08:58AM

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.