Decryption Wizard - Select Script Options

Last Updated: 04.01.2016
The Select Script Options panel will only be displayed if you chose to export the decrypted objects to files on the previous panel. This is where you select the script options and the output location for the exported files. The wizard will comment out the with encryption clause of the decrypted TSQL before the file is written..


Script Options


  • Generate SQL Server Scripts (.sql)

    Checking this box will instruct the wizard to create SQL Server script files.

  • Generate Rich Text Formatted documents (.rtf)

    Checking this box will instruct the wizard to create Rich Tech Formatted documents.

  • Generate 'USE DATABASE' statement

    Checking this option will append a TSQL 'USE DATABASE' statement to the top of the output file. For more information about the 'USE DATABASE' statement please reference https://msdn.microsoft.com/en-us/library/ms188366.aspx.

  • Generate 'DROP' statement

    Checking this option will append a TSQL 'DROP' object statement to the top of the output file and under the 'USE DATABASE' statement, if specified. For more information about the 'DROP' statement please reference https://msdn.microsoft.com/en-us/library/cc879259.aspx.

  • Reformat objects

    Check this option if you want the decrypted TSQL to be reformatted before it is written to the output file.

  • Overwrite existing files

    Check this option to overwrite any files on the file system with the same name (recommended).

  • Output Folder

    Click the ellipsis to the far left of the input box to select the folder that you would like the script files to be written to. The files will be created in the output folder with the following hierarchy:
    Server Alias Name -> Database Name -> Object Type -> Object Parent.Object Schema.Object Name.(sql or rtf)