We help IT Professionals succeed at work.

Oracle to MySQL transfer of table

736 Views
Last Modified: 2012-05-11
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
Comment
Watch Question

Top Expert 2010

Commented:
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

Author

Commented:
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.
Top Expert 2011
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
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..
Top Expert 2011

Commented:
- 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.

Author

Commented:
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..

Author

Commented:
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.
Top Expert 2011

Commented:
- sorry about the download link. should have put it there for you too. however glad that it work for you finally :)
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.