Data Compare synch causes application timeouts

DerekgDerekg Posts: 11
edited January 30, 2009 6:24AM in SQL Data Compare Previous Versions
Does Data Compare cause timeouts/locks in either (or both) the source DB or the destination DB?

The synch itself run pretty well (about 8 mins for a 5GB DB), though occasionally we get timeouts from our web site when the synch is running. Is this normal behavior? Is there something we can do to decrease or eliminate this happening?

Thanks!
· Share on Twitter

Comments

  • Ben PinchenBen Pinchen Posts: 158
    When SQL Data Compare compares the databases it does this without any lock on the tables (we even use WITH NOLOCK). However, when you run the synchronization the destination database will get locks on the specific tables while the transaction is run. This is controlled by SQL Server in the same way that if you just run your own updates\inserts\deletes on a table there will be locks while the data is changing.
    · Share on Twitter
Sign In or Register to comment.