DTM Data Modeler 1.08.04

DTM Data Modeler 1.08.04 provides a perfect 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.

Model Conversion tool allows the user to change target database system for the model easy and fast. The program changes most data types automatically.

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.

Major Features:

1. Well known entity-relationship modeling notation.
2. New level of customization of forward and reverse engineering process.
3. Supports Logical and Physical database models.
4. Database objects tree-like browser. Editors for indexes, stored procedures and triggers
5. Database independent. You can work with Microsoft SQL Server database as well as with Oracle or DB2 database.
6. DTM Data Modeler supports all common database interfaces: ODBC, IDAPI, OLE DB, or Oracle Call Interface.
7. DTM Data Modeler is a true Win32 application, supports Windows 98/ME/2000/XP/2003/Vista/2008.
8. The tool allows you to include procedures, indexes and triggers to model as well as entities (tables) and relationships.
9. Internal ER-model reporting tool creates brief HTML report for data model.
10. Powerful reverse and forward engineering features with template customization feature.
11. Model Conversion tool enables the user to change target database system easy and fast.
12. Scale model option allows to observe model in various views.
13.  "Model Areas" feature allows to work with compact sub-models.
14. Quick start console helps you to access product functions by the one click.

Enhancements:

• Better support for constraint names
• Exclude mask for reverse engineering
• New SQL generation settings and options
• Data Model Conversion tool

Requirements:

• ODBC,IDAPI,OLE DB OCI Interface
• Windows 98/ME/2000/XP/2003/Vista/2008.