SQL Doc generating scripts for encrypted objects
I'm on the newest version of SQL Doc 3.0.7.407.
The documentation states:
Encrypted database objects
SQL Doc doesn't decrypt views, stored procedures, functions, DML triggers, or DDL triggers that are encrypted in a SQL Server 2012, SQL Server 2008, or SQL Server 2005 database. That means SQL Doc can't document the SQL creation script for these encrypted objects.
That's not true. I just ran a project and all of the encrypted objects are clearly scripted.
Granted, these objects can probably be excluded from the generation, but that's not what the documentation clearly states.
thanks
The documentation states:
Encrypted database objects
SQL Doc doesn't decrypt views, stored procedures, functions, DML triggers, or DDL triggers that are encrypted in a SQL Server 2012, SQL Server 2008, or SQL Server 2005 database. That means SQL Doc can't document the SQL creation script for these encrypted objects.
That's not true. I just ran a project and all of the encrypted objects are clearly scripted.
Granted, these objects can probably be excluded from the generation, but that's not what the documentation clearly states.
thanks
Comments
Sorry for the delay in replying to you.
SQL Doc shares some components of SQL Compare. In V3.0.7.407, SQL Doc received an update to the SQL Compare components it uses, hence now SQL Doc will now decrypt the encrypted database objects.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com