Red Gate forums :: View topic - Snapshot vs locking
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare Previous Versions
SQL Compare Previous Versions forum

Snapshot vs locking

Search in SQL Compare Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
Geert Vanhove

Joined: 20 Oct 2011
Posts: 5

PostPosted: Mon Oct 24, 2011 11:32 am    Post subject: Snapshot vs locking Reply with quote

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?
Back to top
View user's profile Send private message
eddie davis

Joined: 14 Jun 2006
Posts: 941
Location: Red Gate Software

PostPosted: Wed Oct 26, 2011 3:57 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group