Compare Database Settings

cfradenburg · August 5, 2015 11:19AM

Is there a way to have SQL Compare not do just objects inside the database but settings as well? I'm particularly thinking of snapshot isolation level but being able to compare other settings would be useful as well. Thank you.

Andrew P · August 7, 2015 1:56PM

Hi Chris,

Thanks for your post!
We can change some settings- the full list of what can be ignored is in the documentation here http://documentation.red-gate.com/displ ... ct+options
Also you can set the Transaction Isolation Level when doing the deployment- by default it is Serializable

Please let me know if that is helpful!
I have also followed up with you via email to resolve any issues.

Warmly,
Andrew Pierce

Niall · September 23, 2015 4:22AM

I would agree with the original request that it would be good if SQL Compare also (optionally) migrated database settings across, that is those that this makes sense for such as 'Paramaterization' as to OP mentioned 'Allow Snapshot Isolation' and others like 'Is Read Committed Snapshot On'.

This is not the isolation level Red-Gate Compare runs under as your reply deals with but the actual settings for the database as can be accessed via SQL Server Management Studio when right clicking on the DB and choosing 'Properties' -> Options.

Mike U · September 23, 2015 6:43AM

Just to let you know, there's a Uservoice request for this feature: https://redgate.uservoice.com/admin/forums/141379-sql-compare/suggestions/9217668-compare-database-settings-such-as-snapshot-isolati. If you'd like this feature added, please add your vote(s) to the request.

Compare Database Settings

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk