Migrating data form ORacle to MySQL
Posted by: Vasudevan Seshadri
Date: September 23, 2005 07:14AM

Hi,

I have a peculier requirement in migrating data from Oracle to MySQL.


All my table names are in upper case (eg : TABLENAME) in oracle and since oracle is not case sensitive all over my application i use multiple case when i refer the table name (eg: tableName).

Hence, basically i need to provide a mapping of tableNames between ORACLE and MySQL meaning

ORACLE MYSQL
-----------------------------------------------------------
TABLENAME tableName
MYTEST myTest


As mentioned in the above example, before creating the tables in the MySQL database we need to check the mapping and create table and then dump the data.

PLEASE NOTE THERE IS NO SCHEMA CHANGE ALL THE COLUMN NAMES REMAIN THE SAME, BUT NEED TO TAKE CARE OF THE TABLE NAME MAPPING.

Is this possible with the current tools provided by MySQL ????

If so what are the procedures.......

Options: ReplyQuote


Subject
Written By
Posted
Migrating data form ORacle to MySQL
September 23, 2005 07:14AM


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.