Online Documentation for SQL Manager for SQL server

Customizing script options

This step allows you to customize common script options and data options for the extraction process.

Script options

Generate "CREATE DATABASE" statement

Check this option to add the CREATE DATABASE statement to the result script.

Generate DROP statements

Check the option to add the DROP statements for the extracted objects in the result script.

With IF statements

Check this option to add the IF keyword to the DROP statements in the result script.

Use IF EXISTS clause for DROP statement

Check this option to add the IF EXISTS clause to the DROP statements in the result script, if available.

Create empty procedures

This option specifies whether procedures with empty bodies are included in the result script or not.

Extract dependent objects

This option determines objects' dependencies usage in the extraction process. Check the option to extract all objects that the selected objects depend on.

Data options

Records in a block / Insert "COMMIT" statement after each block

These controls allow you to define whether the COMMIT statement is added to the script or not, and to specify the number of records in each block to be supplemented with this statement.

Abort extraction on error

This option determines whether the extraction process should be stopped or forced to continue if an error occurs.

Click the Next button to proceed to the last step of the wizard.