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

SQL Console

The tool has a special window where you can specify and execute any SQL statements. You can copy the results of executing a statement onto the clipboard or export it into various formats like text, SQL, HTML, XML or Microsoft Excel. Placing the mouse cursor over the column header will show the type of data stored in this field.

Important: the SQL console does not show any warning before data deletion or modifying.

Note: SQL console shows only begins of large strings. Typically you can view up to 512 first symbols.

DTM Migration Kit: SQL Console

Menu item "Load" allows you to read SQL script from the external file.

There is a picture of local menu accessed by the right click inside the results window.

DTM Migration Kit, SQL console: context menu for result set