How can we help you today? How can we help you today?

Encryption

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
0

Comments

1 comment

Sort by
  • 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.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.