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

Step 6 - Setting up extraction options


At this step you can set the advanced extraction parameters and define query options for data extraction.

 

Metadata options

 

CheckBox Generate CREATE DATABASE statements

Check this option to add the CREATE DATABASE statement(s) to the extraction script.

 

CheckBox Generate DROP DATABASE IF EXISTS statements

Check this option to add the DROP DATABASE IF EXISTS statement to the extraction script.

 

CheckBox Generate DROP IF EXISTS statements

Check the option to add the DROP IF EXISTS statements for the extracted objects.

 

CheckBox Extract privileges

Tick off the option if you want the privileges (permissions on the objects) to be extracted.

 

CheckBox Generate "USE db_name" statement

Check the option to add the USE db_name statement to the result script.

 

CheckBox Generate "SET NAMES" statement

Check this option to add the SET NAMES 'character_set' statement to the result script.

 

CheckBox Extract dependent objects

This option determines the usage of dependencies between objects in the extraction process.

 

CheckBox Disable Foreign key checks

Check this option to add the SET FOREIGN_KEY_CHECKS=0 statement to the extraction script.

 

CheckBox Add SQL_MODE variable

This option specifies that the SET sql_mode='modes' statement will be added to the result script.

 

CheckBox Generate "DELIMITER" statement

Check the option to add the DELIMITER statements for the stored procedures, stored functions and triggers.

 

Extract structure for version ...

This switch control allows you to specify the version of MySQL server the extracted metadata is to be compatible with: Server version, 3.23, 4.0, 4.1, 5.0, 5.1.

 

hs2113 - Step6 - Setting up extraction options

 

 

Data options

 

Records in Block / CheckBox Insert COMMIT after each block

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

 

CheckBox Delete existing records before insert

Generates the DELETE FROM statements before the INSERT INTO statements.

 

CheckBox Extract table data just after definition

If this option is checked, each table is populated after its definition, i.e. each CREATE TABLE statement is immediately followed by the INSERT INTO statements.

 

Data query options

This grid allows you to specify additional options for the SELECT statements used for data extraction.

 

Database Name

This column represents the list of the databases containing the tables selected for data extraction.

 

Limit Data

By setting non-zero values in this column you can limit the number of records extracted from each table.

 

Table Name

This column contains the names of the tables.

 

Table Data Filter

Here you can specify the WHERE clauses for data extraction from each of the tables.

 

Note that you can define data query options not only for a single table, but also for multiple tables at a time by using corresponding items of the context menu of the Data query options grid.

 

Step 6-7 - Context menu

 

 

When you are done, press the Next button to proceed to the next step of the wizard.