Snapshot vs locking
Geert Vanhove
Posts: 9
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?
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?
Comments
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com