Integrated SQL Environment Features

Environment

Operating systems support Windows XP, Vista, 7, Windows 8/10 (desktop), Server 2003, 2008, 2012.
Additional client-side software required ODBC 32, OLE DB, IDAPI/BDE or Oracle Call Interface.
Does the product support any DBMS-specific features? Yes, for MS SQL Server, Oracle, DB2, Informix, PostgreSQL, Sybase and Interbase/Firebird.

SQL editor

Does the script editor built into the product? Yes.
Which third party editors can be integrated with the product? Any (see "Run External Tool" plug-in for more information).
Does the editor support syntax highlighting? Yes, colors and keywords customization is available.
Does the editor support bookmarks? Yes, 10 bookmarks are available.
Does the editor support multilevel Undo/Redo feature? Yes.
Are templates supported? 1) Predefined and user defined macros
2) SQL Library with custom scripts or templates.

Code Formatter

Is a code formatter/beautifier built into the product? No, the auto-indent option only.
Which third party code formatters/beautifiers can be integrated with the product? Any (see "Run External Tool" plug-in for more information).

Code Analysis

Does the product support any built-in analysis of object definitions (queries, index definitions, etc) No.
Which third party code analyzers can be integrated with the product? Any (see "Run External Tool" and preprocessor plug-ins for more information).

Scripts execution

Is execution of SQL built into the product? Yes.
Which third party products can be integrated with this product to support SQL execution? Any (see "Run External Tool" plug-in for more information).
What sort of history is maintained of previously executed statements? Permanent history for any successfully executed statements.
Can multiple SQL statements be executed simultaneously? Yes, for most well known SQL dialects.
Can the execution of an SQL statement be halted once started from within the product? Not for all data sources.
In what format are results viewed? Database grid and additional server messages (if present).
In what format can results be saved? Text (CSV), SQL statements, Microsoft Excel, HTML, XML, RTF (Microsoft Word and Open Office Writer compatible).
How are errors reported back to the user? As a set of message boxes with source statement. Program Log file is available too.

Debugger

Is a debugger built into the product? No.
Which third-part debuggers can be integrated into the product? Not supported.

Performance tuning and optimization

What sort of performance tuning and optimization is built into the product? Execution time and fetch time counters.
Which third party tools can be integrated into the product to support tuning and optimization? Not supported, as plug-in only.

Version Control

What sort of version control is built into the product? MS Visual Source Safe integration.
Which third party tools can be integrated into the product to support change control? Any tools with command line support (see "Run External Tool" plug-in for more information)

Database Schema management

Is a database schema viewer built into the product? Yes
Is an export schema tool built into the product? Yes.
Is a compare schema tool built into the product? No, see DTM Schema Comparer
Is a data synchronization tool built into the product? No, see DTM Data Comparer
Is a schema reporting tool built into the product? No, see DTM Schema Reporter

SQL Statement/Query Builder

Is an SQL builder/Query builder built into the product? Yes.

Assistance/Help

Is help for the tool built into the product? Yes.
Is help for the tool available online? Yes, see online help