What are the challenges you face when working across database platforms? Take the survey


Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited November 9, 2005 7:34AM in SQL Compare Previous Versions
Hi Derek,

Encrypted objects can't be scripted in SQL Comapre or SQL Data Compare,
just as they can't be scripted in Enterprise Manager. If you have a clear
object that you want to be encrypted, you'd have to add those statements to
the migration script manually also.

Thanks again for your interest in Red Gate Software.


Brian Donahue

Technical Support Engineer

Red Gate Software Ltd.

T: +44 870 1600 037

E: mailto:brian.donahue@red-gate.com

"Derek Hart" <dmhart@gte.net> wrote in message
> Can any of Red Gate's products add the WITH ENCRYPTION option when
> SQL objects?
> Derek


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    FYI -- SQL Compare 3.18 and up carry an ADD WITH ENCRYPTION... option in its' list of options. In addition, it can also decrypt objects that are encrypted, provided the user running the software is a SYSADMIN or SECURTITYADMIN on the SQL Server.
This discussion has been closed.