Encryption

Brian Donahue

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.

Regards,

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
news:RFhHwq8rCHA.1152@server53...
> Can any of Red Gate's products add the WITH ENCRYPTION option when
scripting
> SQL objects?
>
> Derek
>
>

Brian Donahue

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.