Online Documentation for SQL Manager for InterBase/Firebird

Customizing script options


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

 

Script options

CheckBox Generate "CREATE DATABASE" statement

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

 

CheckBox Generate "CONNECT DATABASE" statement

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

 

CheckBox Include Password in "CONNECT" and "CREATE DATABASE" statements

Check this option to add the PASSWORD clause to the CONNECT / CREATE DATABASE statements in the result script.

 

CheckBox Generate "CREATE JOURNAL" statement

When this option is enabled, the CREATE JOURNAL statement will be created in the script.

 

CheckBox Generate "DROP" statements for objects

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

 

CheckBox Generate "SET AUTO DDL" statement

Check this option to add the SET AUTO DDL statement, and select whether SET AUTO DDL ON or SET AUTO DDL OFF is to be used in the result script.

 

CheckBox Set generators

Check this option to add the SET GENERATOR statements to the result script.

 

CheckBox Include object descriptions

This option specifies whether object descriptions will be included in the result script or not.

 

CheckBox Include trigger messages

This option specifies whether trigger messages will be included in the result script or not.

 

CheckBox Include privileges

This option specifies whether granted privileges will be included in the result script or not.

 

CheckBox Use dependencies

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

 

Extract Database - Customizing script options

 

Data options

Records in a block / CheckBox 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.

 

CheckBox 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.