What is the best software to draw ERD in Windows for a MySQL database.
Asked
Active
Viewed 9,692 times
6 Answers
3
You can also use staruml
http://staruml.sourceforge.net/en/modules.php
http://staruml.sourceforge.net/docs/StarUML_5.0_Developer_Guide.pdf (see chapter 10 for instruction on creating ER, and installing ER module)
surajz
- 3,471
- 3
- 32
- 38
-
I've used this before and can also highly recommend it – Brock Woolf Jan 13 '10 at 11:38
-
Star UML has been great. Also PSQL Extension https://github.com/adrianandrei-ca/staruml-postgresql – Abram Jan 14 '17 at 02:59
2
I've been using MySQL Workbench for a couple of months now (the community version) and I am very pleased with the result.
MySQL Workbench it is based on DBDesigner4 which was another great tool.
1
If you use a decent web browser on Windows, go try SchemaBank. They have native support for MySQL.
Leigh Pyle
- 238
- 2
- 4
-
For others that see this, SchemaBank.com now redirects to an adware site. – Elijah Lofgren Oct 22 '20 at 21:59
1
I've used an open-source Java-based tool called SchemaSpy recently and it worked very well.
SchemaSpy analyzes schema metadata, letting you click through the hierarchy of tables' parent/child relationships. Works with just about any RDBMS that supports JDBC (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc). Also identifies common anomalies.
rochb
- 2,249
- 18
- 26
0
Visio has a Database Model Diagram template that can be used to draw Entity-Relation Diagrams.
Brandon E Taylor
- 24,881
- 6
- 47
- 71
