WITH ENCRYPTION

sentientpc · January 20, 2012 12:42PM

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 D · January 23, 2012 5:57AM

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

lkalman@financemgr.com · June 13, 2012 1:59PM

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

This would help me out a lot.

lkalman@financemgr.com · March 8, 2013 4:22PM

Any news on adding this feature

David Atkinson · March 9, 2013 9:32AM

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 · March 11, 2013 9:08AM

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

I cant seem to find it.

David Atkinson · March 11, 2013 9:11AM

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

WITH ENCRYPTION

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk