Product Home
DTM Migration Kit Online Documentation Prev Page Prev Page
General Information
Product Profile
User Interface
Quick Start
Transformation Rules
Scheduling
How to...
Settings
Data Preview
Command Line
Console Mode
Project Properties
Hotkeys
Rules
Data Source
Clear Object
Mapping
Functions in Mapping
Data Type Mapping
Execution Control
Export Options
Source Type
Import Options
Schema Migration
Rule Information
Source Object
Target Table
Send e-mail
SQL Files
Records Mode
Additionals
SQL Console
Database Utilities
Trademarks
Installation
Uninstal
License
How to order
Technical Support
Glossary

Output SQL Files Specification

This page helps you to select SQL files for scripts produced during clear, migration or import.

The program generates three optional scripts. There are: all statements, successfully executed statements and rejected statements. The user can switch each type on or off independently.

When "truncate file" option is switched off the program appends new statements to end of specified files.

"Don't execute" option instructs the migration kit to create SQL scripts only but do not actually execute them. Please note that "rejected" list is empty in this case: all statements will be marked as successfully executed.

Also, this page provides a way to specify SQL statement delimiter. The program will add it after each generated SQL statement. The user can select one of predefined values like "go" or ";" or specify custom one.

The transaction size (200 statements by default) allows to tune program performance.
"0" value means automatic commit, i.e. each SQL statement is one transaction.

DTM Migration Kit: output SQL files specification