The Decryption Wizard

Last Updated: 04.01.2016
The Decryption Wizard is a batch object decryption tool capable of decrypting the contents of an entire server at a single time. Encrypted objects can replaced directly on the server or exported to SQL Server scripts (.sql) and Rich Text Formatted files (.rtf).

You can invoke the Decryption Wizard by clicking on the Start Decryption Wizard button on the main menu, by right-clicking on or dragging a server node, database node, or folder node to the Decryption Window. The Decryption Wizard will detect the node type that it was invoked from and auto-select the corresponding options.

There are six possible panels displayed in the Decryption Wizard, depending on which selections are made.


Select Server and Databases

This panel is where you select a SQL Server and one or more databases. For more information please reference the Select Server and Databases topic.


Select Encrypted Objects

This panel is where you select which encrypted object types you would like decrypted. The list of available objects depends on the server and databases selected in the previous panel. For more information please reference the Select Encrypted Objects topic.


Select Output Format

This panel is where you choose how you would like the decrypted objects to be output. For more information please reference the Select Output Format topic.


Select Script Options

If you chose to create SQL Server scripts and/or Rich Text Formatted files then this panel will allow you to specify the details of the exported files. For more information please reference the Select Script Options topic.


Confirm Selections

This panel is where you can review the selections that you made in the previous panels. For more information please reference the Confirm Selections topic.


Object Decryption

This panel is where the objects selected in the previous panels get decrypted and replaced on the server or exported or files. For more information please reference the Object Decryption topic.