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. 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. Also, you can create views and stored procedures as well as basic database model elements.
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.
There is a picture of context menu accessed by the right click on the entity. See the picture below:
Using this menu you can to:
Also, using local Relationship menu you can to:
The object browser tree is located at the left side of the main program window and has context menu too. It allows you to create new database object, to drop an existing object or to edit selected item.
If there is no active database connection when the program is started, it will open the "connection window". To disable this mode, you can use the corresponding option in the settings dialog box.
Note: '*' in the window title means the current project is not saved.DTM Data Modeler is a Win32 application that compatible with the following operating systems: Windows XP, Windows 2003/2008/2012 Server family and Windows Vista, 7, 8/10 (desktop). The 64-bit edition is also available.