DTM SQL Editor Professional

DTM SQL Editor Professional is an advanced software application that comes packed with a built-in SQL editor, offers support for ODBC, IDAPI, and OCI data source connections with detailed database information, script execution tasks, as well as SQL builder (query builder).

The professional edition of the program supports five simultaneous connections, a maximum of ten profiles, and only ten script editing windows. It cannot work with a set of UPDATE statements. If you are looking for unlimited number of connections and additional features, you can have a look at DTM SQL Editor Enterprise.

DTM SQL Editor Professional comes packed with a multitude of configuration parameters so you need to take some extra time and experiment with the options in order to understand how the tool works. You can also appeal to a help manual in order to find out more details about the setup process.

You are given the freedom to work with an SQL editor that features syntax highlighting, multi-level undo/redo options, automatic saving function of the files that you are editing, search and replace mode, and macros to automatically insert repetitive fragments.

What’s more, you can make use of scripts, get a quick view of the database schema and results of the query execution, check out the file history and history of the executed scripts, copy data to the clipboard or export it to plain text, HTML, XML, or Excel documents, as well as save the results as a set of SQL statements. You can work with an SQL builder for generating complex SQL statements using a step-by-step approach and organize useful SQL scripts with the built-in SQL Library.

DTM SQL Editor Professional offers you the possibility to connect to a database using five modes, namely direct connection to various databases (e.g. MS SQL Server, Oracle, Interbase/Firebird, MySQL, PostgreSQL), connection to desktop data files, data source with ODBC, IDAPI, or Oracle Call Interface (OCI), DSN files, and OLE DB.

Other important options worth being mentioned enable you to apply SQL statements (e.g. INSERT, DELETE, DROP TABLE, DROP VIEW, DROP INDEX), boost the functionality of the program with the aid of plugins, as well as appeal to the built-in schema viewer in order to gather details about the tables with indexes, primary, and foreign keys, system tables, synonyms, users for MS SQL, Sybase, and Oracle data sources, databases, stored procedures, queries, access rights for tables and columns, rules, and data types.

To sum things up, DTM SQL Editor Professional proves to be a reliable program that comes packed with a comprehensive suite of database management tools. You can get access to different types of databases and process data in a smart way. The professional edition is suitable for groups that work with several data sources both on database servers and in desktop formats.