Sproc decryption of sql 2005 allowed in Compare but not Doc?

Documents SQL Server 2000, 2005 and 2008 databases.

Sproc decryption of sql 2005 allowed in Compare but not Doc?

Postby wtjones » Fri Nov 28, 2008 3:30 pm

SQL Doc can only decrypt sql 2000 procs as explained here:

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?

Posts: 14
Joined: Tue Jan 08, 2008 3:27 pm

Postby Linda Hawksworth » Mon Dec 01, 2008 9:36 am

I am afraid the ability to decrypt encrypted objects in SQL Server 2005 and 2008 is not available in SQL Doc but it is logged as a feature request in our tracking system and willl be considered for a future release.

You will not be able to use SQL Compare to decrypt the objects to allow SQL Doc to document them either.
Linda Hawksworth
Posts: 192
Joined: Mon Jun 25, 2007 10:32 am

Return to SQL Doc Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests