Discussions

XML & Web services: DB Synchronization

  1. DB Synchronization (4 messages)

    Anyone aware of any tools (XML-based perhaps) that allows you to keep databases synchronized? We are using Oracle and an effort was made a couple of years ago to use Oracle's Symmetric Replication, but was not successful (for reasons I'm not aware of). The client would like us to look for an open XML solution that may be able to syncrhonize their databases.

    Thanks.

    Threaded Messages (4)

  2. DB Synchronization[ Go to top ]

    For what I have seen, it is best to use the native database tools for synchronization. Anything else will be amazingly slow. It would not be hard to write an XML import/export utility, but a million records would be a million inserts (not to mention a huge XML file).
  3. DB Synchronization[ Go to top ]

    I would give Oracle Replication a second chance. True, replication is not easy (with any RDBMS) but it's way easier and more reliable to use than to implement it yourself or using a 3rd party tool. If that's an option for you, check out newer Oracle releases (9i/10g) - AFAIK, replication should have become somewhat easier with these new versions.

    Regards,
    Stefan
  4. DB Synchronization[ Go to top ]

    Anyone aware of any tools (XML-based perhaps) that allows you to keep databases synchronized? We are using Oracle and an effort was made a couple of years ago to use Oracle's Symmetric Replication, but was not successful (for reasons I'm not aware of). The client would like us to look for an open XML solution that may be able to syncrhonize their databases.Thanks.
    http:
    www.XML_based_database_synchronizer.com
  5. Try Daffodil Replicator[ Go to top ]

    Just try out daffodil replicator this can solve ur problems i suppose
    http://www.daffodildb.com/dbreplicator.php