What JDBC tools do you use for synchronization of data sources?

Question!

I'm hoping to find out what tools folks use to synchronize data between databases. I'm looking for a JDBC solution that can be used as a command-line tool.

There used to be a tool called Sync4J that used the SyncML framework but this seems to have fallen by the wayside.



Answers

I'm primarily using Oracle at the moment, and the most full-featured route I've come across is Red Gate's Data Compare:

http://www.red-gate.com/products/oracle-development/data-compare-for-oracle/

This old blog gives a good summary of the solution routes available:

http://www.novell.com/coolsolutions/feature/17995.html

The JDBC-specific offerings I've come across have been very basic. The solution mentioned by Aidos seems the most feature complete if you want to go down the publish-subscribe route:

http://symmetricds.codehaus.org/

Hope this helps.



True synchronization requires some data that I hope your database schema has (you can read the SyncML doc to see how they proceed). Sync4J won't help you much, it's really high-level and XML oriented. If you don't foresee any conflicts (which means: really easy synchronisation), you could try with a lightweight ETL like Enhydra Octopus.

By : Damien B


This video can help you solving your question :)
By: admin