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

WITH ENCRYPTION

I'm attempting to compare our development database vs a production database. When we deploy to production we set SQL Encryption on for all views, procedures, functions and triggers. With SQL Compare its showing that every view, procedure, function and trigger is modified, just because the production side has "WITH ENCRYPTION" for the objects. This forces us to manually evaluate the 1500+ objects that are encrypted to see if anything else has changed.

Is there anyway to ignore the "WITH ENCRYPTION" statement?
sentientpc
0

Comments

6 comments

Sort by
  • Eddie D
    Thank you for your post into the forum.

    I believe that I have already answered your question under support call F0056515.

    Sadly there is not an option to ignore the WITH ENCRYPTION parameter when performing a comparison.

    I have added the details of this support call to an existing feature request whose reference is SC-4419.

    Many Thanks
    Eddie
    Eddie D
    0
  • lkalman
    Can we add to ignore the WITH ENCRYPTION parameter when performing a comparison.

    This would help me out a lot.
    lkalman
    0
  • lkalman
    Any news on adding this feature
    lkalman
    0
  • David Atkinson
    Thanks for the question.

    Please vote for this feature on our UserVoice site. If it gains some traction on UserVoice we will be in a position to consider it.

    David Atkinson
    Red Gate
    David Atkinson
    0
  • lkalman
    What is the link for the User voice site for SQL Compare.

    I cant seem to find it.
    lkalman
    0
  • David Atkinson
    Sorry, forgot to include link!


    http://redgate.uservoice.com/forums/141 ... uggestions

    For the Ignore WITH ENCRYPTION option:

    http://redgate.uservoice.com/forums/141 ... e-with-enc
    David Atkinson
    0

Add comment

Please sign in to leave a comment.