|
|
|
DTM SQL editor, features list
Environment
| Operating systems supported |
Windows 98, ME, 2000, XP, 2003. For Windows NT (without modern IE) MFC library update required. |
| Additional client side software required |
ODBC 32, IDAPI (BDE) or Oracle Call Interface. |
| Does the product support any DBMS-specific features? |
Yes, for MS SQL Server, Oracle, DB2, Sybase and Interbase/Firebird. |
SQL editor
| Does the 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, autoindent 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 statement 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 (MS Word 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. |
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 Builder
| Is a 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 |
|
|
|
• On-line