As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened,
visit the help center for guidance.
Closed 8 years ago.
What is the best software to draw ERD in Windows for a MySQL database.
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)
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.
If you use a decent web browser on Windows, go try SchemaBank. They have native support for MySQL.
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.
Visio has a Database Model Diagram template that can be used to draw Entity-Relation Diagrams.
I've used Toad Data Modeler before with good results.
