What are the challenges you face when working across database platforms? Take the survey

help: persistency !

leholeho Posts: 2
edited June 23, 2006 11:49AM in SQL Compare Previous Versions

We want to use API to synchronize between the local database with 2 other remote databases on the network, if one of the remote database is down during the synchronization, what will happen in this scenario?



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Leho,

    SQL Toolkit (Data Compare, SQL Compare) only allows a 1-on-1 comparison of adatbase schema and data. It isn't capable natively of synchronizing one database to many. I think this would pretty much negate any issue you'd have with rolling back one update if the other one fails, because you can only run one update at a time.
This discussion has been closed.