Run 2 Data compare to same database.

keatackeatac Posts: 3
edited September 29, 2006 6:45AM in SQL Toolkit Previous Versions
I have 2 DB needed to sync to Main DB. what will happen if i sync them at the same time, will the MainDB lock so that db2 can't sync,

for example:
DB1-->MainDB
DB2-->MainDB

Do i need to Lock the Main DB, to sync? :? and how?
or the SQL server will take care for us? :idea:

by the way, i'm using SQLDATACompare, SQL SERVER 2005 EXPRESS.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    It certainly doesn't sound like a good idea. For one thing, even if the updates succeeded, if there was contention for the same record, one database update would supercede the other. This would probably depend on which update query was run first.
  • First thank you for reply..

    basicly our application built for network, but last minute client require to run the application if the network down, so we have to move the DB to local PC, and sync to Server. :?

    so, when SQLDataSync running, will it lock the both database for using?
  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    If you examine the update scripts, you'll have an idea of what is going on. Data Compare's engine is just producing and running a normal SQL script. The whole database isn't going to be 'locked', but there will be locks on the individual tables being updated.
Sign In or Register to comment.