Last Updated: 01.06.2019
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..
Checking this box will instruct the wizard to create SQL Server script files.
Checking this box will instruct the wizard to create Rich Tech Formatted documents.
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.
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.
Check this option if you want the decrypted TSQL to be reformatted before it is written to the output file.
Check this option to overwrite any files on the file system with the same name (recommended).
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)