TMS Data Modeler


Data Modeling, Reverse Engineering, Script Generation and Version Control for all the Major Databases


Clear selection
SKU: N/A Categories: ,

TMS Data Modeler has the Data Modeling features a working Developer needs, in a focussed, productive package:

  • Entity relationship diagram editor (ER diagram)

Design ER diagrams using Data Modeler. You can add tables to the diagram, see the relationships, change display options, and much more.


  • Project validation allows you to trace errors in your model

Data Modeler  validates  your database model checking for design errors. It also displays warnings about your project, such as usage of reserved words and tables with no primary keys, among others. This validation allows fine tuning of your database model, and avoids future problems after your software is in production.


  • Supports logical (application-level) domains

Use domains as an abstraction layer for your data types. Even if your database system doesn’t support domains/user-defined types, you can do it at application level in Data Modeler and make it easy to maintain your databases.


  • Manage many database objects

You can use Data Modeler to manage not only tables and fields, but also indexes, triggers, relationships, constraints, views, procedures, generators, etc. Each database system has its own set of objects available.



  • Reverse engineering of existing databases

Import your existing databases and start using Data Modeler quickly. The reverse engineering tool connects directly to your existing database and extracts all the information you need, such as tables, fields, foreign keys and other objects.



  • Generate SQL (DDL) scripts to create databases

Use Data Modeler to generate the SQL script that will create all your database objects. You can choose which object types to generate.


  • Keep track of your changes by archiving and managing versions

With Data Modeler you can archive project versions/add checkpoints. This way you can have the history of all development stages of database modeling, and also compare between versions and see what has changed from one version to another.



  • Compare models between versions or between projects

A full comparer is available for you to check the differences between two models. You can perform comparison between two versions, or even between two projects. The comparer provides a very friendly visual interface that shows the differences in a tree view and also in a SQL diff format. From the comparer you can choose which items you want to update to generate an Alter SQL script.


  • Generate Alter SQL scripts to update database according to changes

Data Modeler creates SQL scripts to alter your database and update the structure. By using the comparer and/or checking differences, you can easily generate the alter script related to the differences and have your database in sync with your project.


TMS Data Modeler has support for the following databases, with more being added all the time:

  • Absolute Database

  • ElevateDB

  • Firebird

  • MS SQL Server

  • MS SQL Azure

  • MySQL

  • NexusDB

  • Oracle

  • PostgreSQL

  • SQLite