Dtm Data and Dtm Schema Comparer Software for Windows

DTM Data Modeler
$179 - DTM soft

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 (IDEF1X notation) diagram. The product is intended for database architects and developers and works with data sources via the ODBC, OLE DB, IDAPI or Oracle Call 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. The foreign key migration feature makes schema development easier and more visual and also reduces the probability of errors in the integrity of the model. The program can create database schema objects directly in the database as well as to create SQL scripts corresponding to the model and taking into account the settings specified by the user.
The built-in scale and print tools of the model allow you to get a visual representation of the model in the hard copy form for presenting or discussing it. Powerful reverse-engineering tools make it considerably easier to work with existing databases and also provide easy migration from other tools. Both full and selective generation of model objects is available to the user, which makes the product more flexible.

---

---

DTM SQL editor
$129 - 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 desktop or client-server databases (provided you have the ODBC, OLE DB or the IDAPI driver or the OCI interface installed).
DTM SQL editor is especially convenient, since most organizations use several different types of databases and each stores data in different formats and with varying parameters. Having a program that can get data from various sources is essential. In addition to quickly switching between different data sources, DTM SQL editor lets you see the database schema and the results of the query execution.
The program gives you a powerful set of tools to edit SQL scripts and to build SQL statements using a convenient wizard-like interface. The program also includes a connections manager, a database schema viewer, an option to view the execution history and other handy tools conveniently integrated in a single user interface.
The application supports clipboard and data export tools. It can export data to plain text, HTML or XML documents, and Microsoft Excel spreadsheets. You can also save the results of your query as a set of SQL statements.
The other advantages of DTM SQL editor are: one-click access to the file history and the history of the scripts you executed, syntax highlighting, multilevel Undo/Redo features and integrated search and replace tools. The program's step-by-step SQL builder (query builder) is the most intuitive and natural way to build complex SQL statements visually without submersing yourself into SQL.
DTM SQL editor supports plug-ins and comes with an SDK (software developer kit), which allows you to significantly increase the range of possible applications of this program.

---

---

DTM Migration Kit
$159 - DTM soft

Most companies running multiple databases have to deal with complex data import, export and migration issues. After all, importing, exporting or migrating data between different sources is very complicated and time consuming, especially if these data sources store data in different formats. This is where DTM Migration Kit comes to the rescue. This simple yet powerful data migration tool can work fully automatically after being set up only once. In addition to simple import, export or migration operations, the program supports setting custom transformation and flow control rules. Furthermore, DTM Migration Kit works with unified interfaces of ODBC and IDAPI as well as with Oracle Call Interface. It is capable of importing data from plain text, Microsoft Access databases, Microsoft
Excel spreadsheets, Paradox files, DBF (dBase and FoxPro) files and exports data to plain text, RTF format (compatible with Microsoft Word), HTML, XML, as well as is capable of creating sets of SQL statements. Importantly, the export of large binary objects (also known as BLOBs) is supported as well.
DTM Migration Kit uses wizard-like interface that has a very low learning curve and lets virtually any person perform complex data migration tasks. The program can be download and tried free of charge.

---

DTM Schema Inspector
$89 - DTM soft

DTM Schema Inspector is a database schema browsing and management tool (also known as DTM Object Inspector before 2004) that let the user work with database schemas more effectively. The program lets the users work simultaneously with any number of database schemas (metadata) and displays information in a convenient tree-view format, as well as offers current views of database contents and properties. Database schema snapshots support helps the user to browse old states of database objects. Powerful search tool makes navigation for large scale schemas easy. Enable/disable triggers feature (for MS SQL and Oracle only).

---

DTM DB Event
$99 - DTM soft

DTM DB Event is a database monitoring and management tool. This utility allows the user to define a few situations (events). For each event the user can define what the program should do if the event is occur. The program helps the database administrator to perform continuously database status monitoring. Also, if critical events are occurring, the program can make required actions automatically.
For example, if database server is not available, the tool will execute an external program for notification message (alert) sending. It helps company to protect database or minimize downtime. The program will check conditions by the user-defined schedule and execute related action.
Any SQL statement for any user defined database connection can be used for event definition. The user can use a few types of conditions like ?was executed successful?, ?execution error? or define unconditional event. Unconditional event is an event action of that will be executed in any case.
There are three types of events: infinitive, run once or predefined number of checks. The infinitive event will be checked until the program work. The interval between checks for event can be defined by number of seconds, minutes or hours. Also, the user can define delay before the first check after start the program for each event individually.
There are actions that the program can do when event occurs:
1) Do nothing. The user can select it if required action already defined in the event. For example, the program should execute ?Compact? operation for defined database for each 24 hours unconditionally.
2) Execute user defines SQL script.
3) Execute external program or batch file.
4) Write record to program LOG file.
DTM DB Event is a true Win32 application, supports Windows 98/ME/2000/XP/2003 and Vista.

---

DTM Schema Comparer
$139 - DTM soft

DTM Schema Comparer is a visual database schemas comparison tool that supports ODBC, OLEDB, IDAPI and Oracle Call Interface connecctions. The visual representation of database schemas as a tree makes the comparison process more comfortable. The built-in SQL text comparison tool allows you to view two scripts with differences displayed in a comfortable way. The synchronous navigation through the schemas tree allows you to easily compare items in as detailed way as you need.
Key features
* Visual comparison process with tree-view schema presentation.
* Internal database objects text comparison tool.
* Synchronous schemas navigation.
* Database independent. You can compare schema of Microsoft SQL Server database with Oracle database as well as DB2 database schema with Microsoft Access file. DTM Schema Comparer supports all common database interfaces: ODBC, OLE DB, or even Oracle Call Interface.
* DTM Schema Comparer is a true Win32 application, supports Windows 98/ME/2000/XP/2003/Vista.

---