Link to home
Start Free TrialLog in
Avatar of toooki
toooki

asked on

Oracle to MySQL transfer of table

I have a table in Oracle. How can I copy thi stable to a MySQL database?

I have SQL developer and MySQL Workbench.

But cannot find a way to do this...

Oracle is Oralce 11gR2 and MySQL is version 5.x
Avatar of Om Prakash
Om Prakash
Flag of India image

Extract the Oracle table into a delimited flat file and then use the MySQL import utility

http://www.dba-oracle.com/t_copy_oracle_table_mysql.htm
Avatar of toooki
toooki

ASKER

Thank you.
I went to that page before.
I can export from Oracle to a text file (coma separated).
But the tool they mention does not exist at http://www.sqldbu.com/eng/sections/tips/mysqlimport.html.
ASKER CERTIFIED SOLUTION
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of toooki

ASKER

Thank you.
I have both Oracle client and MySQL client installed on my PC.
So I can sqlplus to connect to the Oracle database and mysql to connect to the MySQL database.

I also have Oracle developer, PlSQL developer and MySQL Workbench.

How do I actually copy one table from Oracle to MySQL? I have connection string details of both databases..

One way is to use Oracle dump file and then use that to upload to MySQL. Was wondering any simpler way.

For example, it is possible to do one time table copy from MySQL to Oracle via SQL developer front end. Was looking for just the reverse..
- from the 1st link i give above, it give you step by step to use odbc and using Navicat import wizard to import table from Oracle.
- alternatively you can export the table in Oracle to a text file/csv file using SQL Developer and import back to MySQL using Navicat import wizard. if i'm not mistaken, Workbench have the import feature too.
Avatar of toooki

ASKER

Thank you.
I tried to use MySQL Workbench and yest there is an option but there seems to be restrictions. Some ssh needs to be running on the remote MySQL server ... but I don't have that much option.

Anyway I am a bit stuck with
LOAD DATA INFILE command to upload a record with one field as timestamp data type..
Avatar of toooki

ASKER

OP_Zaharin, Thank you. I went through the link that you sent before:
http://www.webdotdev.com/nvd/content/view/438/

I read the steps but the instruction to download the "MySQL Toolkit" was not there anywhere -- may be all my fault.

Finally I downloaded "mysql-gui-tools-5.0-r17-win32.msi" via Google search. And installed the "MySQL Toolkit". It was easy to use and did the migration of a huge table from Oracle to MySQL very quickly.
Thanks.
- sorry about the download link. should have put it there for you too. however glad that it work for you finally :)