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
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 12:53 pm
- Location: Leicester
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".
- Posts: 6668
- Joined: Mon Aug 23, 2004 10:48 am
Return to SQL Compare 10
Who is online
Users browsing this forum: No registered users and 0 guests