Online Documentation for DB Extract for InterBase/Firebird

Extract Options section


Section [#ExtractOptions#] stores values set on Step 6 of Wizard application.

 

The configuration parameters are listed below.

 

CreateDatabaseStmt

0 = Do not add CREATE DATABASE statement to the extraction script.

1 = Add CREATE DATABASE statement to the extraction script.

 

 

 

DropTableStmt

0 = Do not add DROP statements for the extracted objects

1 = Add DROP statements for the extracted objects to the result script

 

RecordsInBlock

The number of INSERT statements in a block after which the COMMIT statement is to be added

 

InsertCommit

0 = Do not insert COMMIT statement after each block

1 = Insert COMMIT statement after each block

 

DeleteAllRecords

0 = Do not delete any records from the tables before the INSERT statements

1 = Delete all records from the tables before the INSERT statements

 

 

Privileges

0 = Do not include access privileges for the extracted objects

1 = Include access privileges for the extracted objects

 

ExtractDependentObjects

0 = Extract dependent objects

1 = Do not extract dependent objects

 

IncludeObjectDescriptions

0 = Do not include object description to the result script

1 = Include object description to the result script

 

IncludeTriggerMessages

0 = Do not include trigger messages into the result script

1 = Include trigger messages into the result script

 

IncludePassword

0 = Do not include password into "CONNECT" and "CREATE DATABASE" statements in the result script

1 = Include password into "CONNECT" and "CREATE DATABASE" statements in the result script

 

SetGenerators

0 = Add the statement that sets current generator values

1 = Do not add the statement that sets current generator values

 

 

 

 

BlobExtractType

0 = Do not extract BLOB fields

1 = Extract BLOB fields to strings

2 = Extract BLOB fields into file

 

BlobSingleFile

0 = BLOB fields will be extracted into a number of files

1 = BLOB fields will be extracted into a single file

 

BlobComressionLevel

0 = None

1 = Fastest

2 = Normal

3 = Best

 

AddDateTimeToBlob

0 = Do not add the current date and time to BLOB filename(s)

1 = Add the current date and time to BLOB filename(s)

 

AddDateTimeTypeBlob

0 = Date will be added to BLOB filename(s)

1 = Time will be added to BLOB filename(s)

2 = Datetime will be added to BLOB filename(s)

 

 

 

ArrayExtractType

0 = Do not extract array fields

1 = Extract array fields into a file