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.
What is the best tool to create a use-case diagram and an entity-relationship model? Update Cancel. Which is the best tool for creating ERD? Some UML tools have a facility for creating database diagrams (e.g. Visual Paradim Plus) and will allow you to export SQL statements that can be used to.
General[edit]
Tool | Creator | Target Business Size | License | Supported Database Platforms | Supported OSs | Standalone or bundled into a larger toolkit | Launch Date |
---|---|---|---|---|---|---|---|
Astah | Change Vision | Enterprises | Proprietary | MySQL, Oracle, | Windows, macOS, Linux | Standalone | 2006 |
Database Deployment Manager | The Unauthorized Frog project | SMBs and enterprises | LGPL | CUBRID, MySQL, SQLite | Windows, Linux | Standalone | 2010 ? |
Database Workbench | Upscene Productions | SMBs and enterprises | Proprietary | MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB | Windows, Linux and FreeBSD (both through Wine) | Standalone | 2001 |
Enterprise Architect | Sparx Systems | SMBs and enterprises | Proprietary | IBM DB2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, Sybase | Windows, Linux (Wine), macOS (via CrossOver) | Data modeling is supported as part of a complete modeling platform. | 2000 |
ER/Studio | Embarcadero (acquired by IDERA) | SMBs and enterprises | Proprietary | Access, IBM DB2, Informix, Hitachi HiRDB, Firebird, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQL | Windows | Standalone | 1998 |
Erwin Data Modeler | ERWin (formerly CA) | SMBs and enterprises | Proprietary | Access, IBM DB2, Informix, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, and others via ODBC/ANSI SQL | Windows | Standalone | 1998 |
MagicDraw | No Magic | Enterprises, SMBs, personal | Proprietary | MS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2 | Windows, Linux, macOS | Standalone | 1995 |
SQL Server Management Studio | Microsoft | Unknown | Proprietary | MS SQL Server | Windows | Standalone | 2005 |
ModelRight | ModelRight | Enterprises, SMBs, personal | Proprietary | Access, MS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2 | Windows | Standalone | 2005 |
MySQL Workbench | MySQL (An Oracle Company) | SMBs - personal | Proprietary or GPL | MySQL | Linux, Windows, macOS | Standalone | 2006 |
Navicat Data Modeler | PremiumSoft | SMBs and enterprises | Proprietary | MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite | Windows, macOS, Linux | Standalone | 2012 |
NORMA Object-Role Modeling | Terry Halpin | SMBs and enterprises | CPL | MySQL, MS SQL Server, PostgreSQL, Oracle, DB2 | Windows | Visual Studio Extension | 2005 |
Open ModelSphere | Grandite | Enterprises - SMBs - personal | GNU GPL3 | MS SQL Server, MySQL, PostgreSQL, Oracle, DB2 | Windows, macOS, Linux | Standalone with Data, UML, and process modeling | 2008 |
Oracle SQL Developer Data Modeler | Oracle | Enterprises | Proprietary | Oracle, MS SQL Server, IBM DB2 | Cross-platform | Standalone | Unknown |
PowerDesigner | SAP | SMBs and enterprises | Proprietary | Access, Greenplum, Apache Hive, HP Neoview, IBM DB2, Informix, Ingres, Interbase, MySQL, Netezza, NonStop SQL, Oracle, PostgreSQL, Red Brick Warehouse, SAP business Suite, SAP Hana, SAP Adaptive Server Enterprise, SAP IQ, SAP SQL Anywhere, MS SQL Server, Teradata | Windows | Standalone | 1989 |
Software Ideas Modeler | Dusan Rodina | Enterprises, SMBs, personal | Proprietary | MS SQL Server, MySQL | Windows | Standalone | 2009 |
SQLyog | Webyog, Inc. | Enterprises, SMBs, personal | Proprietary | MySQL, MariaDB | Windows and Linux (using Wine) | Standalone | 2001 |
Toad Data Modeler | Quest Software | SMBs and enterprises | Proprietary | Access, IBM DB2, Informix, MySQL, MariaDB, PostgreSQL, MS SQL Server, SQLite, Oracle | Windows | Standalone | 2005 (before this date known as CaseStudio) |
Tool | Creator | Target Business Size | License | Supported Database Platforms | Supported OSs | Standalone or bundled into a larger toolkit | Launch Date |
Features[edit]
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 (Crows feet) | Yes | Yes | Update database and/or update model | No |
Enterprise Architect | Conceptual, Logical & Physical + MDA Transform of Logical to Physical | IDEF1X, UML DDL, Information Engineering & ERD | Yes | Yes | 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 (Crows feet) | Yes | Yes | Update database and/or update model | ER/Studio Repository and Team Server (formerly Portal/CONNECT) for collaboration |
MagicDraw | Conceptual, Logical & Physical + MDA Transform of Logical to Physical | IDEF1X, UML DDL, Information Engineering & ERD | Yes | Yes | 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 (Crows feet), UML, and more | Yes | Yes | Update database and/or update model | No |
Navicat Data Modeler | Conceptual, physical | IE (Crows feet) | Yes | Yes | Update database and/or update model | No |
NORMA Object-Role modeling | Conceptual (ORM), Logical, Physical | ORM, Relational(Crows feet option), Barker | Yes | Yes | Update database and/or update model | No |
Open ModelSphere | Conceptual, Logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | No |
Oracle SQL Developer Data Modeler | Logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes |
PowerDesigner | Conceptual, logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes |
Toad Data Modeler | Logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes |
See also[edit]
Retrieved from 'https://en.wikipedia.org/w/index.php?title=Comparison_of_data_modeling_tools&oldid=916534837'
ER Diagram Tool or entity relationship model diagram is a very useful tool in case of hospitality management and in day to day managing activities of any corporate firms. In this article, we are going to discuss some of the ER Diagram tool free download and are also going to discuss eight of the most popular ER Diagram tool online that can be used and download. Since the article focuses on free software we are going to base our list to ER diagram tool open source that are available in the market.
![Best Best](/uploads/1/2/4/1/124124550/480792208.png)
Related:
Database Design ER Diagram
The first software in our list is the Visual Paradigm software named after the company and is distributed by the same, it is a very powerful ER diagram tool that can be used as a trial for some time, and after that it is available with a price tag depending on the type of user you select during registration.
Online ER Diagram
Since being online is the most recent trend of the modern society, the next software in our list is a software that can be used to make entity relationships model online and it has some restrictions as a free user, but the professional members can use many advanced stuff and tools that come with this powerful beast.
ER Diagram Tool
Apart from providing some very helpful training on how to make a great entity relationship model Lucid Chart is a software distributing platform which provides ER diagram tool free download. The software can be used in Windows mainly but there is an extension to use this software on other platforms.
Entity Relationship Diagram
Edraw Visualization studio presents their entity relationships diagram software that is available for a small price tag, but a free trial for the software is available and it is free for a lifetime in student version with limited functionality. The software is robust and can perform very powerful functions and can also be integrated with Microsoft office to make the software more easy to use.
Entity Relationship Diagram Tool
A powerful software that has many other features like reverse engineering, software compatibility, and availability is the ER diagram too from Case Studio. The software has a limited trial period, and if you want all its features which have no comparison like the others then you will definitely going to need this.
Database Diagram Online
Another online entity relationship model making software that is available only in paid version is the database diagram online from GenMy model. A software which has built-in tools for decision making, reverse engineering, and other functions and all of these can be used online, or it is also available if you want to work with them offline, and you can store and sync the data to the cloud whenever and where ever required.
Free ER Diagram Tool
As promised in the beginning of the article, this is a Free ER Diagram Tool download link, which can do all the works that a professional paid version software can do and also has very good tools that can be used along with the software.
ConceptDraw PRO ER Diagram Tool – Most Popular Software
ER diagram tool like this one can be rarely found in the online marketplace or even in the offline stores, and this is the most popular one, in term of entity relationship model diagram making a tool, from Concept Draw. The company provides all the function in its pro version, which obviously, comes with a price tag. You can also see Flowchart Software
How to Install an ER Diagram Tool?
An ER Diagram tool, once downloaded can be installed in a pretty quick steps and then you are ready to do some of the professional drawings that you want to do for a long time, or you want to learn this technology which can help you in your career growth, then these software can start you with the basics. You can also see Database Design Tools
First, you will need to know how to handle an ER Diagram tool, of which there are many online tutorials and then you can use any of these software, and they all have some ‘how to’ guide in their official product release websites from where you can download the software and make use of it.