Product Home
DTM Data Comparer Online Documentation Prev Page Prev Page
General
Product profile
Connect
Quick Start
Direct Connection
Connect to Desktop File
Data Sources
DSN File
OLE DB Connection
Connection Profile
Connection Information
Troubleshooting Guide
Comparison
Synchronization
Table to Table Mode
Synchronous Navigation
Face-to-Face View
Database Mode
Key Definition
Column Mapping
Settings
General Settings
User Interface
Comparison Settings
Synchronization Settings
Report Settings
Project Properties
Script Viewer
Command Line
Console Mode
Process Cancellation
Comparison Report
Collate Window
Run SQL statement
SQL Console
Hot Keys
Information
Limitations
Support
License
Demo and Full versions
Install
How to buy
Upgrade
Uninstall
Products
Trademark Information
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 Data Comparer: 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 Data Comparer, SQL console: context menu for result set