Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

share

migration rejected from stackoverflow.com 4 hours ago

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.

put on hold as too broad by Colin 't Hart, RolandoMySQLDBA, Phil, Vérace, Mark Storey-Smith 4 hours ago

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.

2  
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: stackoverflow.com/questions/3992573/… –  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 6 hours ago
    
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 5 hours ago

2 Answers 2

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.

share

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).

share