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

ToolCreatorTarget Business SizeLicenseSupported Database PlatformsSupported OSsStandalone or bundled into a larger toolkitLaunch Date
AstahChange VisionEnterprisesProprietaryMySQL, Oracle,Windows, macOS, LinuxStandalone2006
Database Deployment ManagerThe Unauthorized Frog projectSMBs and enterprisesLGPLCUBRID, MySQL, SQLiteWindows, LinuxStandalone2010 ?
Database WorkbenchUpscene ProductionsSMBs and enterprisesProprietaryMS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDBWindows, Linux and FreeBSD Standalone2001
Enterprise ArchitectSparx SystemsSMBs and enterprisesProprietaryIBM DB2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, SybaseWindows, Linux, macOS Data modeling is supported as part of a complete modeling platform.2000
ER/StudioEmbarcadero SMBs and enterprisesProprietaryAccess, IBM DB2, Informix, Hitachi HiRDB, Firebird, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQLWindowsStandalone1998
Erwin Data ModelerERWin SMBs and enterprisesProprietaryAccess, IBM DB2, Informix, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, and others via ODBC/ANSI SQLWindowsStandalone1998
MagicDrawNo MagicEnterprises, SMBs, personalProprietaryMS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2Windows, Linux, macOSStandalone1995
SQL Server Management StudioMicrosoftProprietaryMS SQL ServerWindowsStandalone2005
ModelRightModelRightEnterprises, SMBs, personalProprietaryAccess, MS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2WindowsStandalone2005
MySQL WorkbenchMySQL SMBs - personalProprietary or GPLMySQLLinux, Windows, macOSStandalone2006
Navicat Data ModelerPremiumSoftSMBs and enterprisesProprietaryMySQL, MS SQL Server, PostgreSQL, Oracle, SQLiteWindows, macOS, LinuxStandalone2012
NORMA Object-Role ModelingTerry HalpinSMBs and enterprisesCPLMySQL, MS SQL Server, PostgreSQL, Oracle, DB2WindowsVisual Studio Extension2005
Open ModelSphereGranditeEnterprises - SMBs - personalGNU GPL3MS SQL Server, MySQL, PostgreSQL, Oracle, DB2Windows, macOS, LinuxStandalone with Data, UML, and process modeling2008
Oracle SQL Developer Data ModelerOracleEnterprisesProprietaryOracle, MS SQL Server, IBM DB2Cross-platformStandalone2009
PowerDesignerSAPSMBs and enterprisesProprietaryAccess, 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, TeradataWindowsStandalone1989
Software Ideas ModelerDusan RodinaEnterprises, SMBs, personalProprietaryMS SQL Server, MySQLWindowsStandalone2009
SQLyogWebyog, Inc.Enterprises, SMBs, personalProprietaryMySQL, MariaDBWindows and Linux Standalone2001
Toad Data ModelerQuest SoftwareSMBs and enterprisesProprietaryAccess, IBM DB2, Informix, MySQL, MariaDB, PostgreSQL, MS SQL Server, SQLite, OracleWindowsStandalone2005
ToolCreatorTarget Business SizeLicenseSupported Database PlatformsSupported OSsStandalone or bundled into a larger toolkitLaunch Date

Features

ToolSupported data models Supported notationsForward engineeringReverse engineeringModel/database comparison and synchronizationTeamwork/repository
Database WorkbenchConceptual, logical, physicalIE Update database and/or update model
Enterprise ArchitectConceptual, Logical & Physical + MDA Transform of Logical to PhysicalIDEF1X, UML DDL, Information Engineering & ERDUpdate database and/or update modelMulti-user collaboration using File, DBMS or Cloud Repository.
ER/StudioLogical, physical, ETLIDEF1X, IE Update database and/or update modelER/Studio Repository and Team Server for web based publishing collaboration and model management, with Business Glossary as standard.
MagicDrawConceptual, Logical & Physical + MDA Transform of Logical to PhysicalIDEF1X, UML DDL, Information Engineering & ERDUpdate database and/or update modelMulti-user collaboration using File, DBMS or.
MySQL WorkbenchPhysicalIDEF1X, IE, UML, and moreUpdate database and/or update model
Navicat Data ModelerConceptual, physicalIE Update database and/or update model
NORMA Object-Role modelingConceptual, Logical, PhysicalORM, Relational, BarkerUpdate database and/or update model
Open ModelSphereConceptual, Logical, physicalIDEF1X, IE, and moreUpdate database and/or update model
Oracle SQL Developer Data ModelerLogical, physicalIDEF1X, IE, and moreUpdate database and/or update model
PowerDesignerConceptual, logical, physicalIDEF1X, IE, and moreUpdate database and/or update model
Toad Data ModelerLogical, physicalIDEF1X, IE, and moreUpdate database and/or update model