hi all,
i am looking for the best software to draw ERD in windows for a mysql database.
A:
Visio has a Database Model Diagram template that can be used to draw Entity-Relation Diagrams.
Brandon E Taylor
2009-08-16 05:29:07
+1
A:
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.
Jacobo
2009-08-16 07:06:12
+1
A:
If you use a decent web browser on Windows, go try SchemaBank. They have native support for MySQL.
Leigh Pyle
2009-10-07 09:01:14
+1
A:
You can also use staruml
http://staruml.sourceforge.net/en/modules.php
http://staruml.sourceforge.net/docs/StarUML%5F5.0%5FDeveloper%5FGuide.pdf (see chapter 10 for instruction on creating ER, and installing ER module)
surajz
2009-11-06 22:05:52
I've used this before and can also highly recommend it
Brock Woolf
2010-01-13 11:38:38
A:
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
2010-01-13 11:42:53