www.sqledit.com
DTM SQL editor Online Documentation
General
Product profile
Product versions
Database tools
Install software
Upgrade software
Uninstall software
System requirements
How to buy
Product features
User interface
Hot keys
SQL editor
Search and replace
Data export
SQL library
Results viewer
Connect to database
Macros: definition and using
Database schema viewer
Find database object
Data editor
Schema object
Filter database schema
Version control
Command line options
Settings and options
SQL builder
SQL builder
Select type of the statement
Specity objects for select
Build WHERE cause
Select tables or views
Select one table or view
Select fields
Set or change values
ORDER BY and GROUP BY
Create table
Create index
Create view
Plug-ins and SDK
Plug-ins and SDK
Data structures
Plug-in sample, sources
Plug-ins Library
General information
Directory by DBMS
MS SQL Server
Run Query Analyzer
Oracle
Run SQL*Plus
General
Insert Module Header
External preprocessor
Run external tool
Run after script execution
Save/Load Hisroty
Send script by e-mail
Simply preprocessor
WinDiff interface
Directory by functions
Editor plug-ins
Insert Module Header
Run external tool
Run Oracle SQL*Plus
Run MS Query Analyzer
Send script by e-mail
Schema plug-ins
Results plug-ins
Common plug-ins
Run WinDiff
Save/Load Hisroty
Preporcessors
External preprocessor
Simply preprocessor
After execution plug-ins
Run after script execution
Information
Licence agreemnet
Technical support
Send feedback
FAQ and tips
Program tutorial
Troubleshooting guide
Glossary
SQL reference
SQL quick reference

Database utilities by DTM soft

DTM SQL Editor is a set of powerful database management tools that allow you to achieve two goals - to have unified access to different types of databases and to have a set of solutions that makes processing your data easy. DTM SQL Editor gives database users, developers and administrators an ability to access different databases, whether desktop or client-server ones (provided you have ODBC driver installed). This is very convenient, since most organizations use several different types of databases installed and each stores data in different formats and with varying parameters. Having a program that can get data from various sources is often essential. Furthermore, in addition to letting you quickly switch between different data sources, DTM SQL Editor lets you see database schema and results of the query execution.

DTM Migration Kit is a powerful yet simple data migration tool that comes in handy if you run multiple databases. Use it to import, export or migrate data between different data sources (ODBC, IDAPI, or Oracle Call Interface supported). The program is fully automatic and supports all popular database formats. Simple visual interface lets you set own transformation and flow control rules to give you added flexibility.

DTM Schema Reporter is a reporting tool for database schema. The program creates reports in RTF, HTML, XML or plain text formats and supports all common database interfaces - ODBC, IDAPI, or even Oracle Call Interface. This utility helps technical writers and database administrators create a report of any complexity level within seconds. Also, you can alter table order in the report and manually add annotations to the individual tables.

DTM Data Generator is a simple, powerful and fully customizable utility that generates data for database testing purposes. Currently, database developers and administrators often have to spend hours of dull work to create test data sets before examining database performance. This tool makes all this unnecessary by automatically creating database objects AND sets of SQL statements, if necessary.

DTM Data Editor is a data viewer and editor for database professionals who are tired of wasting their time on mundane tasks. The program uses form-based interface and works with any ODBC data source. SQL statements are generated automatically and can by modified later. For data that has foreign key - primary key relation, there are options to enter values manually or select them from a list, which is much faster.

DTM DB Stress is a utility for stress testing the server parts of information systems and applications, as well as DBMSs and servers themselves. This tool allows you to create and configure a continuous set of requests to the server of the OLAP (query execution) and OLTP (adding, modifying and deleting data in the database) types. At the same time, the user can flexibly change both the number and the priority of this or that type of requests to a database or an application.

DTM Data Modeler is a CASE tool for database developers that supports both forward and reverse engineering. It is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship diagram. The product is intended for database architects and developers and works with data sources via the ODBC interface, which means compatibility with all modern DBMS. Along with basic model properties (sets of entities and relationships between them), the program allows you to create indexes and triggers on the physical level corresponding to the tables of the database that is modeled.

DTM Data Scrubber is a set of intelligent tools for data verification (audit) and scrubbing (cleaning). Depending on user-defined rules and data properties, the program either creates a report about the actual state of affairs or performs database data correction.

DTM Data Comparer is a visual tool for data compare and synchronization. The program successively views the contents of both tables basing on the order of ascending of unique key values and shows differences or creates synchronization script.

DTM Schema Comparer is a tool for comparing database schemas. The comparison process supports tables, views, indexes, triggers and stored procedures. The visual representation of database schemas as a tree makes the comparison process more comfortable.