Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to sync data between Oracle & MySQL databases. What is the best possible way to achieve this?

Are there any tools/software available?

This is not a one-time but an ongoing operation. The data set is also quite large, containing almost 300 tables.


migration rejected from Sep 4 '15 at 18:29

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too broad by Colin 't Hart, RolandoMySQLDBA, Phil, Vérace, Mark Storey-Smith Sep 4 '15 at 18:29

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

Is this a one-time operation? Or an ongoing operation? If ongoing, how frequently? How large is the data set? – Justin Cave Feb 21 '12 at 17:46
There are DBLinks in Oracle to Link to multiple database engines:… – Karlson Feb 21 '12 at 18:17
Which direction would you like to go in? The Title says MySQL->Oracle and the question states the opposite. Does this need to happen in realtime, or be batched? – Phil Apr 27 '12 at 16:11
What's your criteria for "best"? What you describe is usually called heterogeneous replication, so you may want to google this term and rephrase your question to be more specific if something remains unclear. – mustaccio Sep 4 '15 at 17:20
I think that you should try/benchmark/test different tools and then get back to us if you have particular issues. As it is, your question is too broad and I'm afraid that I'm going to have to vote to close - if you revise, we can reopen :-) p.s. welcome to the forum. – Vérace Sep 4 '15 at 17:27

Take a look at Tungsten Replicator, which can replicate MySQL to Oracle and Oracle to MySQL (this is not a one-time import but an ongoing replication).


A tool specifically setup for this task is Oracle GoldenGate. It supports bi-directional replication amongst others between Oracle and mysql. For documentation start here: otn Oracle GoldenGate overview

For a onetime operation cheaper alternatives exist but for something that should be running and keep running for longer periods of time, GoldenGate is your friend.