Text was Encrypted even though Decrypt Encrypted Objects set

[whitecar]

Hi

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

[Brian Donahue]

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
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521