Comparison of data modeling tools

This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment.

General

Features

{, class="sortable wikitable" style="width: auto; text-align: center;"
! Tool
! Supported data models (conceptual, logical, physical)
! Supported notations
! Forward engineering
! Reverse engineering
! Model/database comparison and synchronization
! Teamwork/repository
, -
, Database Workbench
, Conceptual, logical, physical
, IE (Crow’s foot)
,
,
, Update database and/or update model
,
, -
, Enterprise Architect
, Conceptual, Logical & Physical + MDA Transform of Logical to Physical
, IDEF1X, UML DDL, Information Engineering & ERD
,
,
, Update database and/or update model
, Multi-user collaboration using File, DBMS or Cloud Repository (or transfer via XMI, CVS/TFS or Difference Merge).
, -
, ER/Studio
, Logical, physical, ETL
, IDEF1X, IE (Crow’s feet)
,
,
, Update database and/or update model
, ER/Studio Repository and Team Server (formerly Portal/CONNECT) for web based publishing collaboration and model management, with Business Glossary as standard.
, -
, MagicDraw
, Conceptual, Logical & Physical + MDA Transform of Logical to Physical
, IDEF1X, UML DDL, Information Engineering & ERD
,
,
, Update database and/or update model
, Multi-user collaboration using File, DBMS or (transfer via XMI, CVS/TFS or Difference Merge).
, -
, MySQL Workbench
, Physical
, IDEF1X, IE (Crow’s feet), UML, and more
,
,
, Update database and/or update model
,
, -
, Navicat Data Modeler
, Conceptual, Logical & Physical
, IE (Crow’s foot)
,
,
, Update database and/or update model
,
, -
, NORMA Object-Role modeling
, Conceptual (ORM), Logical, Physical
, ORM, Relational(Crow’s foot option), Barker
,
,
, Update database and/or update model
,
, -
, Open ModelSphere
, Conceptual, Logical, physical
, IDEF1X, IE (Crow’s foot), and more
,
,
, Update database and/or update model
,
, -
, Oracle SQL Developer Data Modeler
, Logical, physical
, Barker, IE (Crow’s foot), and Bachman
,
,
, Update database and/or update model
,
, -
, PowerDesigner
, Conceptual, logical, physical
, IDEF1X, IE (Crow’s foot), and more
,
,
, Update database and/or update model
,
, -
, Software Ideas Modeler
, Conceptual, logical, physical
, IDEF1X, IE (Crow’s foot), UML and more
,
,
, Update database and/or update model
,
, -
, Toad Data Modeler
, Logical, physical
, IDEF1X, IE (Crow’s foot), and more
,
,
, Update database and/or update model
, {{yes

See also

* Comparison of database administration tools
* List of Unified Modeling Language tools
* Data modeling
* IDEF1X

D