Red Gate forums :: View topic - Sproc decryption of sql 2005 allowed in Compare but not Doc?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 1
SQL Doc 1 forum

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

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
wtjones



Joined: 08 Jan 2008
Posts: 14

PostPosted: Fri Nov 28, 2008 4:30 pm    Post subject: Sproc decryption of sql 2005 allowed in Compare but not Doc? Reply with quote

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

Quote:
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:

Quote:
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
Back to top
View user's profile Send private message
Linda Hawksworth



Joined: 25 Jun 2007
Posts: 192

PostPosted: Mon Dec 01, 2008 10:36 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group