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
System:
Oracle: couple GB
MySQL: v. 5.0.xx
OS: Windows XP
Human resource: oracle, java developer
Look forword for any ideas...
Thanks,
molo
Subject
Views
Written By
Posted
Smart solution for mapping of data migration Oracle to MySQL
6131
January 25, 2007 08:58AM
3261
June 16, 2008 05:25AM
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.