WITH ENCRYPTION

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

WITH ENCRYPTION

Postby sentientpc » Fri Jan 20, 2012 6:42 pm

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
 
Posts: 1
Joined: Fri Jan 20, 2012 6:40 pm

Postby eddie davis » Mon Jan 23, 2012 11:57 am

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
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

ignore the WITH ENCRYPTION parameter

Postby lkalman@financemgr.com » Wed Jun 13, 2012 6:59 pm

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

This would help me out a lot.
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

WITH ENCRYPTION

Postby lkalman@financemgr.com » Fri Mar 08, 2013 10:22 pm

Any news on adding this feature
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby David Atkinson » Sat Mar 09, 2013 3:32 pm

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby lkalman@financemgr.com » Mon Mar 11, 2013 2:08 pm

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

I cant seem to find it.
lkalman@financemgr.com
 
Posts: 22
Joined: Wed Apr 11, 2012 2:03 pm

Postby David Atkinson » Mon Mar 11, 2013 2:11 pm

David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest