Snapshot vs locking

Forum for users of SQL Compare schema synchronization utility

Snapshot vs locking

Postby Geert Vanhove » Mon Oct 24, 2011 10:32 am

When comparing 2 databases I noticed locking on the source DB.
Would a compare using a snapshot of the source db be a solution?
Would the creation of the Snapshot also generate locks?
How can these snapshots be cleaned up?
Geert Vanhove
Posts: 5
Joined: Thu Oct 20, 2011 2:23 pm

Postby eddie davis » Wed Oct 26, 2011 2:57 pm

Thank you for your post into the forum and sorry that SQL Compare maybe the cause to a locking issue.

Comparing from a snapshot file maybe a solution for you to try. You still may experience a locking situation during the period that the snapshot file is being generated. However the creation of the snapshot file is generally does not produce a huge overhead.

Are you able to provide further details on the locking issue you are experiencing? Is the server very busy at the time the comparison takes place?

Alternatively, there is a little utility that will generate a SQL Compare Snapshot file for you called SQL Snapper which is available as a free download HERE.

There is not a feature within SQL Compare for management of snapshot files. I can submit a feature request on your behalf to request this be added in a future version of the product?

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1148
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 0 guests