Database Modeling Software Features

Environment

Operating systems support Windows XP, Vista, 7, Server 2003, 2008, 2012.
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, IBM DB2, SQLite, MS Access, MySQL, Sybase and Interbase/Firebird.

Forward Engineering

Does the modeling tool support partial target database generation? Yes.
Can the Data Modeler drop an existing objects before creation? Yes.
Does the program support generation of ALTER statements instead of CREATE? Yes.
Does the user allowed to customize SQL statements to be generated? Yes, complete templates for generic and most popular database systems are supplied.

Reverse Engineering

Does the data modeler support selection of objects to be extracted from existing database? Yes, by name and by mask.
What kind of objects can be retrieved? Tables, views, indexes, triggers, stored procedures, keys and relationships, defaults, comments.

Modeling

Does the data modeler support areas? Yes.
Does the data modeler enable the user to create a model without database connection? Yes, the user can use generic data type set or select one of the most popular database like Oracle, SQL Server, etc.
Can the DTM Data Modeler convert a model from one database system to another? Yes, with model conversion tool.
Does the program allow to add free text notes to model? Yes.
Does the data modeler support custom background colors for tables/entities? Yes.
Does the software product support custom fonts for individual model? Yes.
Does the CASE utility support primary key migration feature? Yes, with a few options.
Can the modeling tool copy and export model view as an image? Yes, as windows bitmap.
Has the modeling tool built-in model reporting tool? Yes, simple tool with HTML output only is included. Please try out DTM Schema Reporter for more flexible and powerful reports.

Assistance/Help

Is help for the tool built into the product? Yes.
Is help for the tool available online? Yes, see online help

See Also