Is there a better app to create Entity Relationship Diagrams than the Sql Server or mySQL studios?

2016-12-04T22:49:17-05:00

Just figured out how to make an Entity - Relationship Diagram in mySQL workbench - 1 man hour. Now I'm tired.

Response by MAJ Private RallyPoint Member made Dec 5 at 2016 9:28 AM

2016-12-05T09:28:15-05:00

Personally, I still use MSSQL Server Management Studio, since that's where I do most of my other DB development too, or (more lately) Visual Studio's SQL Server Data Tools add-on (I know it works in VS2013, and I think it's automatic in 2015) using a SQL *project* type, since it allows me to develop the schema, procedures, and ERD more easily without actually changing tables in the DB and also integrates with source control well by virtue of VS's existing capabilities.

That said, there are plenty of alternative tools available, and many are at least a bit more friendly than the SQL studios are. Here's someI've seen floating around:
https://erdplus.com/
https://www.lucidchart.com/pages/tour/ER_diagram_tool
http://www.sqlpower.ca/page/architect_download_os
As for recommendations, that's harder. Each tool gives a different feel, and you just have to see if one fits what you're looking for. The only one I've used is ERD Plus, and while it was nice, I still prefer working inside an IDE.

ERDPlus

ERDPlus is a database modeling tool to quickly and easily create Entity Relationship Diagrams, Relational Schemas, and Star Schemas.