How to migrate data from oracle db to mysql db?

Question

I have an Oracle database and I want to migrate data to a Mysql database since I'm trying to configure an application to work with Mysql.

I tried this using Mysql Workbench Migration Wizard, but I am unable to connect to the Oracle database.

I got this error:

"The specified DSN contains an architecture mismatch between the Driver an Application"

And I also got http://bugs.mysql.com/bug.php?id=66609 link and it says that Workbench doesn't support Oracle.

Are there any other free tools to migrate data from Oracle to Mysql ?

Or any other alternatives to get this done?

I have used SQlyog for this. But it is a paid version.But any way you can download trail and check — Sathish D, Nov 22 '13 at 09:28
http://stackoverflow.com/questions/19701377/mysql-connect-import-a-tabele-of-oracle-database — Sathish D, Nov 22 '13 at 09:29

score 0 · Answer 1 · answered Nov 22 '13 at 11:01

0

Export to excel and import it with SQL Navicat Premium mysql

answered Nov 22 '13 at 11:01

Agoeng Liu

674
3
10
30

score 0 · Answer 2 · answered Nov 25 '13 at 08:38

0

MySQL Workbench has a dedicated migration module, supporting various source RDBMS (provided they have a JDBC driver) as well as MySQL to MySQL transitions (e.g. for upgrading or migrating a MySQL server to a new machine).

MySQL Workbench is free. For more informations, downloads, blogs etc see http://mysqlworkbench.org

answered Nov 25 '13 at 08:38

Mike Lischke

48,925
16
119
181

MySQL Workbench doesn't support Oracle to MySQL though, and any attempts to use the tool for Oracle to MySQL will not work. – PinkElephantsOnParade Jul 17 '17 at 13:33

score 0 · Answer 3 · answered Nov 27 '13 at 10:25

0

With FoxWeave, an integration tool, you can also migrate data from oracle db to mysql db.

answered Nov 27 '13 at 10:25

Captain Haddock

488
2
7

How to migrate data from oracle db to mysql db?

3 Answers3