EMS logo

Products Navigation

DB Extract for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS DB Extract for SQL Server

On-line Documentation

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

 

 

 

 

 

 

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)

 

 

AddUse

0 = Do not add the USE DATABASE statement to the beginning of the script

1 = Add the USE DATABASE statement to the beginning of the script

 

PrintObjectName

0 = Do not add PRINT <object name> statement before extraction

1 = Add PRINT <object name> statement before extraction

 

UseCollations

0 = Do not use collations for the extraction process

1 = Use collations for the extraction process

 

 

 

 


See also:

General and Connection sections

Common Options section

File Options section

Scheduled Task sections

Data Query sections

Databases section