How do I convert an Oracle database to MySQL?

Question

Is there a recommended tool to convert an Oracle database including (stored procedures) into MySQL?

@user720210 - If you're looking for a simple tool that you can just run, I don't think you'll find one. Oracle is much more complicated, powerful, and expensive than MySQL and can't necessarily be simplified down with the push of a button. You'll probably need to create a new database in MySQL that's as similar to your oracle database as you can make it and then port whatever code/data you need to to run on the new system. — Joshua Carmody, Apr 25 '11 at 19:03
I can't think of any automated way to do such a task. You will need to rewrite all procs manually and make sure they still have the same results, mysql and Oracle have very different flavors of SQL and there is no easy way to convert as far as I know. Even if you used an automated tool, you would have to test each proc becuase an automated tool would probably not get all changes correct for complex queries such as those in procs. — HLGEM, Apr 25 '11 at 19:06
Similar answer here: http://stackoverflow.com/questions/2479500/migrate-from-oracle-to-mysql/11774222#11774222 — Jacob, Aug 02 '12 at 09:27

score 3 · Accepted Answer · edited May 23 '17 at 12:24

3

I've asked a similar question and from the answers I got I can recommend OmegaSync, although I did not try to migrate stored procedures, but it's supported too.

edited May 23 '17 at 12:24

Community

1
1

answered Apr 26 '11 at 05:40

CloudyMarble

36,908
70
97
130

score 1 · Answer 2 · edited Nov 27 '16 at 13:28

1

Try the MySQL forums: How to migrate database from Oracle 10g to MySQL

You will need a MySQL administrator, or specifically Navicat (MySQL GUI).

edited Nov 27 '16 at 13:28

Peter Mortensen

30,738
21
105
131

answered Apr 25 '11 at 19:03

IAbstract

19,551
15
98
146

score 1 · Answer 3 · edited Nov 27 '16 at 13:30

1

You can try to investigate the MySQL Migration Toolkit. It claims to be able to migrate from Oracle, but it has reached its EOL. I am not sure if it can help you if you're using the latest versions of Oracle or MySQL. It's replacement is MySQL Workbench.

edited Nov 27 '16 at 13:30

Peter Mortensen

30,738
21
105
131

answered Apr 25 '11 at 19:13

Jurri

318
2
8

score 1 · Answer 4 · edited Nov 27 '16 at 13:31

1

I can recommend the open source business intelligence software Pentaho. I suppose it supports MySQL too.

edited Nov 27 '16 at 13:31

Peter Mortensen

30,738
21
105
131

answered Apr 27 '11 at 19:50

user722891

19
2

No more open source. – Rafael Herscovici Apr 27 '15 at 14:04

How do I convert an Oracle database to MySQL?

4 Answers4

Linked