Sproc decryption of sql 2005 allowed in Compare but not Doc?
wtjones
Posts: 21
SQL Doc can only decrypt sql 2000 procs as explained here:
It appears that SQL Compare can do this:
Will this be added to SQL Doc? In the meantime, would I be able to first use compare to decrypt and then have Doc spit out the procs?
Thanks
you are documenting a SQL Server 2000 database that contains an encrypted user-defined function, stored procedure, trigger, or view and you have system administrator permissions, SQL Doc can decrypt the object and you can view its internal SQL.
However, views, stored procedures, functions, DML triggers, and DDL triggers that are encrypted in a SQL Server 2008 or SQL Server 2005 database cannot be decrypted. Therefore, SQL Doc cannot document the creation SQL for these encrypted objects.
It appears that SQL Compare can do this:
In SQL Compare version 7.1 (and later) you have the option to decrypt text objects in SQL Server 2005 and SQL Server 2008 databases created using the WITH ENCRYPTION option.
Will this be added to SQL Doc? In the meantime, would I be able to first use compare to decrypt and then have Doc spit out the procs?
Thanks
Comments
You will not be able to use SQL Compare to decrypt the objects to allow SQL Doc to document them either.