How can we help you today? How can we help you today?

Compare Database Settings

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.
cfradenburg
0

Comments

3 comments

Sort by
  • Andrew P
    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
    L0Ow3nk.png

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

    Warmly,
    Andrew Pierce
    Andrew P
    0
  • Niall
    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.
    Niall
    0
  • Mike U
    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.
    Mike U
    0

Add comment

Please sign in to leave a comment.