EMS logo

Products Navigation

DB Extract for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS DB Extract for MySQL

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.

 

DropDatabase

0 = Do not add DROP DATABASE IF EXISTS statement to the extraction script.

1 = Add DROP DATABASE IF EXISTS statement to the extraction script.

AddSqlModeVariable

0 = SET sql_mode='modes' statement will not be added to the result script.

1 = SET sql_mode='modes' statement will be added to the result script.

 

GenerateDelimiter

0 = Do not add the DELIMITER statements for the stored procedures, stored functions and triggers.

1 = Add the DELIMITER statements for the stored procedures, stored functions and triggers.

 

GenerateSetNames

0 = Do not add the SET NAMES 'character_set' statement to the result script.

1 = Add the SET NAMES 'character_set' statement to the result script.

GenerateUseDB

0 = Do not add the USE db_name statement to the result script.

1 = Add the USE db_name statement to the result 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

 

 

 

 

 

(s)

(s)

(s)

 

 

 

 

DisableKeys

0 = Do not disable foreign key checks

1 = Disable foreign key checks

 

 


See also:

General and Connection sections

Common Options section

File Options section

Scheduled Task sections

Data Query sections

Databases section