WITH ENCRYPTION

[sentientpc]

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?

[eddie davis]

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 Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com

[lkalman@financemgr.com]

Can we add to ignore the WITH ENCRYPTION parameter when performing a comparison.

This would help me out a lot.

[lkalman@financemgr.com]

Any news on adding this feature

[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

[lkalman@financemgr.com]

What is the link for the User voice site for SQL Compare.

I cant seem to find it.

[David Atkinson]

Sorry, forgot to include link!


http://redgate.uservoice.com/forums/141379-sql-compare-feature-suggestions

For the Ignore WITH ENCRYPTION option:

http://redgate.uservoice.com/forums/141379-sql-compare-feature-suggestions/suggestions/2935916-in-project-options-add-option-to-ignore-with-enc