Data Compare synch causes application timeouts

DerekgDerekg Posts: 11
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!

Comments

  • 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.
Sign In or Register to comment.