Text was Encrypted even though Decrypt Encrypted Objects set

Forum for users of SQL Compare schema synchronization utility

Text was Encrypted even though Decrypt Encrypted Objects set

Postby whitecar » Wed Dec 21, 2011 2:55 pm


Can anyone help with this matter. I've set the above option and yet I'm getting 750+ objects that exist in both databases but are different. The description for this option suggests that these objects would be decrypted.
Also can some objects be partially encrypted because I'm getting tables that seem identical when scripted out but which when compared have "Test was Encrypted" between some of the Go statements.

Thanks in advance for any guidance on this :?
Posts: 1
Joined: Wed Dec 21, 2011 11:53 am
Location: Leicester

Postby Brian Donahue » Fri Dec 23, 2011 4:01 pm

Thanks for your post. Usually you can clear this up by ensuring your have sysadmin rights on the server. The decryption requires access to the server key and rights to do page dumps. If you don't have the rights, the comparison goes ahead, and all encrypted objects say "text was encrypted" but the status for these objects will always be "different".
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests