views:

1380

answers:

3

Are there any free tools available for generating ERDs from an existing MySQL database? I've been given the requirement to generate such documentation for a legacy database and would prefer to not have to do it by hand.

+6  A: 

MySQL Workbench? http://wb.mysql.com/

Andrei Serdeliuc
From what i gather the specific feature of reverse engineering is not free in MySQL workbench. The "Reverse engineer" function is the commercial edition of MySQL Workbench.
Peter Lindqvist
+3  A: 

I believe Toad supports RE (reverse engineering):

http://www.toadsoft.com/toadmysql/Features.htm

  • Quickly diagram all tables in a schema.
AJ
+1  A: 

If you by free mean "free for a one-time assignment", you could have a look at Visual Paradigm and use the demo version.

If you need to reverse-engineer and the update/continue working on it i would try the Mysql Workbench as pointed out by Apikot.

Another option would be Toad Data modeler which i believe would be up to task.

Quote from Toad Data Modeler

Reverse engineer already existing database structures and see the existing database structure in form of a diagram.

Peter Lindqvist