Reverse Engineer MySQL 1

[tweenerz]

Does anyone know of any tools (preferrably free, but not necessary) that can reverse engineer a mysql database and generate an er diagram.

In other words, I would like a tool, kinda like visio, that can receive mysql sql (DDL) and automatically create an er diagram from that with all the entities, attributes, keys, etc.

Thanks

 

[lgarner]

Check out DBDesigner4 at

http://www.fabforce.net.

One of its features is "Reverse engineering MySQL, Oracle, MSSQL and any ODBC databases

 

[tweenerz]

lgarner:

Thanks a bunch. This is definitely one of the better open source tools I have encountered. This saved me a lot of time.

I love the fact that it creates relationships based on fields names - what a plus.

Thanks again!