Red Gate forums :: View topic - WITH ENCRYPTION
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

WITH ENCRYPTION

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sentientpc



Joined: 20 Jan 2012
Posts: 1

PostPosted: Fri Jan 20, 2012 6:42 pm    Post subject: WITH ENCRYPTION Reply with quote

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?
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 936
Location: Red Gate Software

PostPosted: Mon Jan 23, 2012 11:57 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
lkalman@financemgr.com



Joined: 11 Apr 2012
Posts: 22

PostPosted: Wed Jun 13, 2012 6:59 pm    Post subject: ignore the WITH ENCRYPTION parameter Reply with quote

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

This would help me out a lot.
Back to top
View user's profile Send private message Send e-mail
lkalman@financemgr.com



Joined: 11 Apr 2012
Posts: 22

PostPosted: Fri Mar 08, 2013 10:22 pm    Post subject: WITH ENCRYPTION Reply with quote

Any news on adding this feature
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Sat Mar 09, 2013 3:32 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
lkalman@financemgr.com



Joined: 11 Apr 2012
Posts: 22

PostPosted: Mon Mar 11, 2013 2:08 pm    Post subject: Reply with quote

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

I cant seem to find it.
Back to top
View user's profile Send private message Send e-mail
David Atkinson



Joined: 05 Dec 2005
Posts: 1122
Location: Twitter: @dtabase

PostPosted: Mon Mar 11, 2013 2:11 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group