Comparison of data modeling tools - AbsoluteAstronomy.com

This article is a comparison of data modeling
Data modeling
Data modeling in software engineering is the process of creating a data model for an information system by applying formal data modeling techniques.- Overview :...

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

General

Tool	Creator	Target Business Size	License	Supported Database Platforms	Supported OSs	Standalone or bundled into a larger toolkit	Launch Date
CA ERwin Data Modeler CA ERwin Data Modeler CA ERwin Data Modeler is a software tool for data modeling of custom developed information systems, including databases of transactional systems and data marts...	CA Technologies	SMBs and enterprises	Commercial (Free, limited, community edition available)	Access, IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... , Informix Informix IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions... , Ingres Ingres Ingres Database is a commercially supported, open-source SQL relational database management system intended to support large commercial and government applications... , MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , Progress, MS SQL Server, Sybase Sybase Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms.... , Teradata	All versions of Windows	Standalone	1992?
Database Visual Architect	Visual Paradigm	SMBs and enterprises	Commercial	IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... , Firebird, Progress OpenEdge, Cache, MS SQL Server, MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , HSQLDB, SQLite SQLite SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard... , Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , Sybase Sybase Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....	Windows, Linux Linux Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds... , MAC OS	Standalone (or as part of an UML modeling environment)	Unknown
dbConstructor	DBDeveloper Solutions	SMBs	Commercial	Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , MS SQL Server, MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , Access	All versions of Windows	Standalone
DbSchema	Wise Coders Solutions	SMBs	Commercial	MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , MS SQL Server, Derby, Firebird, Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... , Informix Informix IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions... , HSql, Pointbase, Mimer, Pervasive, Sybase Sybase Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....	All versions of Windows	Standalone	2005
DbWrench Database Design	Nizana Systems	SMBs	Commercial	MS SQL Server, Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...	Windows, Linux, Mac	Standalone	2005
DeZign for Databases DeZign for Databases DeZign for Databases is a database design and data modeling tool for multiple database platforms . It can be used to create, maintain and document new or existing database systems. The tool uses Entity-relationship diagram...	Datanamic Datanamic Datanamic is a software company based in Leiden, The Netherlands. It was founded in 1999. It provides tools for database designers, developers and administrators...	SMBs and enterprises	Commercial	MS SQL Server, MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... , Firebird, InterBase, Informix Informix IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions... , MS Access, SQLite SQLite SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , Sybase Sybase Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms.... , Paradox	All versions of Windows	Standalone	1999
Enterprise Architect Enterprise architect Enterprise architects are practitioners of enterprise architecture; an information technology management discipline that operates within organizations.-Role of enterprise architects:...	Sparx Systems	SMBs and enterprises	Commercial	IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... , Firebird, InterBase, Informix Informix IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions... , Ingres, Access, MS SQL Server, MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , SQLite SQLite SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard... , Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , Sybase Sybase Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....	All versions of Windows	Data modeling is supported as part of a complete modeling platform.	2000
ER/Studio ER/Studio ER/Studio is data architecture and database design software developed by Embarcadero Technologies. It works across multiple database platforms and is used by data architects, data modelers, database administrators and business analysts to create and manage database designs, document and reuse data...	Embarcadero Embarcadero Embarcadero may refer to:* Embarcadero , California** Embarcadero Circle, waterfront re-development project* Embarcadero , California Embarcadero Center, office complex Embarcadero Freeway, former California State Route 480...	SMBs and enterprises	Commercial	Access, IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... , Informix Informix IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions... , MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , MS SQL Server	All versions of Windows	Standalone	1998
IBM InfoSphere IBM InfoSphere IBM Infosphere is a branded product line from IBM under its Information Management Software brand, announced in February 2008, which includes software products from its WebSphere and Information Server product lines... Data Architect	IBM IBM International Business Machines Corporation or IBM is an American multinational technology and consulting corporation headquartered in Armonk, New York, United States. IBM manufactures and sells computer hardware and software, and it offers infrastructure, hosting and consulting services in areas...	Enterprises	Commercial	IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... , Informix Informix IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions... , Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , Sybase Sybase Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms.... , MS SQL Server, MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , Teradata	Linux Linux Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds... , Windows	Standalone
MicroOLAP Databaser Designer	MicroOLAP	SMBs	Commercial	MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software...	All versions of Windows	Standalone	2003
MySQL Workbench MySQL Workbench MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system...	MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... (An Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... Company)	SMBs - personal	Commercial	MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...	Linux Linux Linux is a Unix-like computer operating system assembled under the model of free and open source software development and distribution. The defining component of any Linux system is the Linux kernel, an operating system kernel first released October 5, 1991 by Linus Torvalds... , Windows, MAC OS	Standalone	2006
Online Data Modeler	JenaSoft	SMBs - personal	Commercial	MS SQL Server, MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , SQLite SQLite SQLite is an ACID-compliant embedded relational database management system contained in a relatively small C programming library. The source code for SQLite is in the public domain and implements most of the SQL standard... , MS Access	Online	Standalone	2011
Open ModelSphere Open ModelSphere Open ModelSphere is a data, process and UML modeling tool written in Java and released under the open source GPL License. It provides support for forward and reverse engineering between UML and relational schemas.-History:...	Grandite	SMBs - personal	Commercial and free edition available	MS SQL Server, MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My...	Online	Part of modeling environment with UML UML UML may refer to:* Unified Modeling Language, an object modeling and specification language used in software engineering* User-mode Linux, an architectural port of the Linux kernel* University of Massachusetts Lowell, in the United States... support	2010
Oracle SQL Developer Oracle SQL Developer In computing, Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development Kit.- Features :... Data Modeler	Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination....	Enterprises	Free	Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , MS SQL Server, IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions...	Cross-platform	Standalone
PowerDesigner PowerDesigner PowerDesigner is a collaborative enterprise modelling tool produced by Sybase. PowerDesigner runs under Microsoft Windows as a native application, and runs under Eclipse through a plugin. PowerDesigner supports model-driven architecture software design. PowerDesigner uses the .pdm file...	Sybase Sybase Sybase, an SAP company, is an enterprise software and services company offering software to manage, analyze, and mobilize information, using relational databases, analytics and data warehousing solutions and mobile applications development platforms....	SMBs and enterprises	Commercial	MS SQL Server, Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... , Informix Informix IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions...	All versions of Windows	Standalone	1996
SQL Power Architect	SQLPower Software	SMBs	Commercial and free community edition	PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , MS SQL Server	Windows	Standalone	2004
Toad Data Modeler Toad Data Modeler Toad Data Modeler is a database design tool allowing users to visually create, maintain and document new or existing database systems. It was previously called "CASE Studio 2" before it was acquired from Charonware by Quest Software in 2006...	Quest Software Quest Software Quest Software is a computer software manufacturer headquartered in Aliso Viejo, California. Founded in 1987, Quest develops, manufactures and supports software used by Information Technology professionals in a variety of industries...	SMBs and enterprises	Commercial (Free, limited, community edition available)	Access, IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions... , Informix Informix IBM Informix is a family of relational database management system developed by IBM. It is positioned as IBM's flagship data server for online transaction processing as well as integrated solutions... , MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , MS SQL Server	All versions of Windows	Standalone	2005 (before this date known as CaseStudio)
XCase	Resolution Software Ltd	SMBs and enterprises	Commercial	MS SQL Server, Oracle Oracle In Classical Antiquity, an oracle was a person or agency considered to be a source of wise counsel or prophetic predictions or precognition of the future, inspired by the gods. As such it is a form of divination.... , PostgreSQL PostgreSQL PostgreSQL, often simply Postgres, is an object-relational database management system available for many platforms including Linux, FreeBSD, Solaris, MS Windows and Mac OS X. It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software... , MySQL MySQL MySQL officially, but also commonly "My Sequel") is a relational database management system that runs as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius' daughter, My... , IBM DB2 IBM DB2 The IBM DB2 Enterprise Server Edition is a relational model database server developed by IBM. It primarily runs on Unix , Linux, IBM i , z/OS and Windows servers. DB2 also powers the different IBM InfoSphere Warehouse editions...	All versions of Windows	Standalone	1996
Tool	Creator	Target Business Size	License	Supported Database Platforms	Supported OSs	Standalone or bundled into a larger toolkit	Launch Date

Features

Tool	Supported data models (conceptual, logical, physical)	Supported notations	Forward engineering	Reverse engineering	Model/database comparison and synchronization	Teamwork/repository
CA ERwin Data Modeler CA ERwin Data Modeler CA ERwin Data Modeler is a software tool for data modeling of custom developed information systems, including databases of transactional systems and data marts...	Conceptual, logical, physical	IDEF1X, IE (Crows feet), and more			Update database and/or update model	Workgroup edition provides collaboration
Database Visual Architect	Physical	Crows feet			Update database and/or update model	Additional product Teamwork Server for collaboration.
dbConstructor	Physical	Crows feet			Update database
DbSchema	Physical	Crows feet			Compare to database and generate alter database script (update existing model not supported).
DbWrench Database Design	Physical	Crows feet			Update database and/or update model
DeZign for Databases DeZign for Databases DeZign for Databases is a database design and data modeling tool for multiple database platforms . It can be used to create, maintain and document new or existing database systems. The tool uses Entity-relationship diagram...	Logical, physical	IDEF1X, IE (Crows feet)			Update database and/or update model	Not directly. Merge functionality available.
Enterprise Architect	Conceptual, Logical & Physical + MDA transform Logical to Physical	IDEF1X, UML DDL, Information Engineering & ERD			Update database and/or update model	Provides several methods for collaboration (CVS, database, merge)
ER/Studio ER/Studio ER/Studio is data architecture and database design software developed by Embarcadero Technologies. It works across multiple database platforms and is used by data architects, data modelers, database administrators and business analysts to create and manage database designs, document and reuse data...	Conceptual, logical, physical	IDEF1X, IE (Crows feet)			Update database and/or update model	Additional ER/Studio Repository for collaboration
IBM InfoSphere IBM InfoSphere IBM Infosphere is a branded product line from IBM under its Information Management Software brand, announced in February 2008, which includes software products from its WebSphere and Information Server product lines... Data Architect	Conceptual, logical, physical	IDEF1X, IE (Crows feet), and more			Update database and/or update model
MicroOLAP Databaser Designer	Physical	Crows feet			Update database with alter scripts
MySQL Workbench MySQL Workbench MySQL Workbench is a visual database design tool that integrates SQL development, administration, database design, creation and maintenance into a single integrated development environment for the MySQL database system...	Physical	IE (Crows feet)			Update database and/or update model
Navicat Navicat Navicat is a series of graphical database management and development software produced by PremiumSoft CyberTech Ltd. for MySQL, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote...	Conceptual, physical	IE (Crows feet)			Update database and/or update model
Online Data Modeler	Logical, physical	IDEF1X (incomplete)			Update database (update model unknown)
Open ModelSphere Open ModelSphere Open ModelSphere is a data, process and UML modeling tool written in Java and released under the open source GPL License. It provides support for forward and reverse engineering between UML and relational schemas.-History:...	Logical, physical	IDEF1X, IE (Crows feet), and more			Update database and/or update model
Oracle SQL Developer Oracle SQL Developer In computing, Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development Kit.- Features :... Data Modeler	Logical, physical	IDEF1X, IE (Crows feet), and more			Update database and/or update model
PowerDesigner PowerDesigner PowerDesigner is a collaborative enterprise modelling tool produced by Sybase. PowerDesigner runs under Microsoft Windows as a native application, and runs under Eclipse through a plugin. PowerDesigner supports model-driven architecture software design. PowerDesigner uses the .pdm file...	Conceptual, logical, physical	IDEF1X, IE (Crows feet), and more			Update database and/or update model
SQL Power Architect	Physical	IDEF1X, IE (Crows feet), and more			Compare models and generate alter script
Toad Data Modeler Toad Data Modeler Toad Data Modeler is a database design tool allowing users to visually create, maintain and document new or existing database systems. It was previously called "CASE Studio 2" before it was acquired from Charonware by Quest Software in 2006...	Logical, physical	IDEF1X, IE (Crows feet), and more			Update database and/or update model
XCase	Physical	IDEF1X, IE (Crows feet), and more			Update database and/or update model	Not directly. Merge functionality available.
Tool	Supported data models (conceptual, logical, physical)	Supported notations	Forward engineering	Reverse engineering	Model/database comparison and synchronization	Teamwork/repository

General

Features

See also