Red Gate forums :: View topic - Compare not detecting ALLOW_SNAPSHOT_ISOLATION
Return to www.red-gate.com RSS Feed Available

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

Compare not detecting ALLOW_SNAPSHOT_ISOLATION

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
paulh



Joined: 08 Oct 2005
Posts: 33

PostPosted: Mon Jul 07, 2014 10:27 am    Post subject: Compare not detecting ALLOW_SNAPSHOT_ISOLATION Reply with quote

I'm doing a full compare but SQL Compare is not detecting the ALLOW_SNAPSHOT_ISOLATION setting

Is it not supported or do I have to change other parameters?

Paul
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6643

PostPosted: Wed Jul 09, 2014 2:51 pm    Post subject: Reply with quote

Hi Paul,

I don't believe SQL Compare is meant to synchronize any database-level configuration properties, except when required to add an object, for instance enabling FULLTEXT so that it can synchronize a full text catalog.

If this setting is causing an object synchronization to fail, I can definitely put in a change request for SQL Compare to support it.
Back to top
View user's profile Send private message
paulh



Joined: 08 Oct 2005
Posts: 33

PostPosted: Thu Jul 10, 2014 12:46 pm    Post subject: Reply with quote

Brian

The background was that we are doing application development against a database and hit a throughput problem, so we changed the transaction option from serializable to snapshot, which requires the ALLOW_SNAPSHOT_ISOLATION setting to work.

The issue is that every other bit of the database, schema, tables, views, indices etc in in source control which means we can promote changes through the environments in a controller manner - except for this one!

I'd suggest having a database settings comparison section so that we can choose whether these are synchronised or not, ok it's not schema synchronization but it does make a difference to the functionality of the database and if it's out of sync can break applications.
Back to top
View user's profile Send private message
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