A Detailed Comparison of Data Modeling Tools
source link: https://dzone.com/articles/data-modeling-tools-comparison
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
A Detailed Comparison of Data Modeling Tools
This article is a detailed comparison of the most notable data modeling tools in the market, according to their core features.
Join the DZone community and get the full member experience.
Join For FreeA data modeling tool or a database modeling tool is an application that helps data modelers to create and design databases structure. Thus, data modeling tools make the Data modeling process easier and provide many features that help data modelers to understand their data.
Actually, there are many different data modeling tools available for different database platforms. This multitude of tools available makes it very difficult to choose a tool that suits the user's needs.
In this article, I aim to provide a detailed comparison of the most notable data modeling tools in the market. The tools will be compared according to the core features they have.
Some features do not appear on the comparison table because they are available in almost every tool.
I will compare the following tools:
I have tried to focus on the tools that only do data modeling; I excluded the tools that do more than data modeling. I have selected only the most well-known multi-DBMS tools on the market.
Detailed Comparison of Data Modeling Tools
(Note: Scroll to the left and right to see all the products compared)
Via JDBC: Access, Informix, Interbase, Sybase, MS SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Firebird, Azure SQL Database, Amazon Redshift, MariaDB, and more
MS SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Firebird, Azure SQL Database, Amazon Redshift, Amazon RDS, MariaDB
IE(Crow's feet), IE with Arrows, Barker
and more Reverse/Forward Engineering
a data model ✓ - ✓ ✓ ✓ - - Secure connection
to the Database SSH - SSL SSH/SSL SSH/SSL SSH/HTTP
/SSL SSL/SSH Import from
local and remote databases ✓ ✓ ✓ ✓ ✓ ✓ ✓ Model Validation Model validation Check - ✓ ✓ ✓ ✓ - ✓ Validate a model using a database sandbox - - ✓
(Virtual test
data
& built-in
query tool) - - - - Reporting Generate Model Documentation HTML (navigable), PDF HTML (navigable), PDF, MS Word HTML
(navigable) XML, HTML, RTF HTML, Xls, Doc PDF, HTML, Excel HTML, RTF, PDF Print diagram ✓ ✓ ✓ ✓ ✓ ✓ ✓ Advanced tools Comparison Model/Model
Model/Model
Model/Model
Model/Model
Model/Model
Model/Database Model/Model Model/Database Model/Database Model/Database Model/Database Model/Database - Model/ SQL Scripts Database/Database Model/ SQL scripts Model/ SQL scripts - - - - Database/ Database - Model to Model - - Model to Model Database to Model Model to Model Synchronization Model to Database Model to Database Model to Database Model to Database Model to Database Database to Model Database to Model Database to Model Database to Model Database to Model Model to SQL file Model to SQL file Database to Model Populate a Database with Test Data
(Directly on the database)
-(Directly on the database and SQL Script)
- - - ✓(By SQL Script) Change Database Platform ✓ ✓ ✓ ✓ ✓ ✓ ✓ Multi-Projects Management ✓
(Multi-Instance) ✓ ✓ ✓ ✓ ✓
(Multi-Instance) ✓ Version Management - ✓ ✓ ✓ ✓ ✓ Find and Replace Find Only ✓ ✓ ✓ ✓ Find Only Find Only Collaboration
/Teamwork GIT, Mercurial, SVN, CVS, etc. Repository database GIT ER/Studio
Repository Workgroup Edition Navicat Cloud GIT,
SVN Last release
8.5.0
Jan 2022
12.4.2
Jul 2021
5.0.1
Dec 2021
19.1.0
Nov 2021
2021 R1
Apr 2021
3.1.6
Jan 2022
Oct 2020
Major updates every: 2 or 3 Months 6 Months 2 or 3 Months 4 to 6 months 6 months 3 or 4 years 5 Months Price for 1 user/perpetuallicense From $63
to $197 From $228
to $959 From $49
to $499 Starts at
$4,000 Starts at
$3,143 From $129
to $459 Starts at
$293
Conclusion
Some tools may support many database platforms but crash frequently such as DBSchema and Toad. Other tools have small missing features that probably slowed you down in your data modeling process. For example, DeZign doesn’t have a Re-do action! Navicat and DBSchema do not have enough details on the description of the fields. ERBuilder supports only the physical model.
Tools such as ERWin and ER/Studio are complete data modeling solutions, but they can be quite complex and difficult to use. Also, their prices are very high compared to the other tools.
As a result of this comparison, we come to the conclusion that testing each product seems to be the best way to find the best tool for your needs; don't just rely solely on the features that these data modeling tools support.
References
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK