Database diagram -> sql

January 26, 2011 8:58 AM

Help me find a program (Windows / preferably free) that draws database diagrams and then creates the relevant SQL...

I always draw my database diagrams in Dia and then enter the tables and columns in phpMyAdmin. It works, but it's duplicating effort.

I'm being pushed to use Eclipse and Clay, but there's something about my laptop that causes Eclipse to behave in unexpected ways. The last time I tried it I wasted a days work before our Eclipse expert gave up on it.

Can anyone recommend some software that does something similar?

posted by sodium lights the horizon to computers & internet (5 answers total)

I don't have a suggestion but it sounds like you are looking for a tool for "ER" or "entity relationship" diagrams, which might helpn with the google. Some can also generate diagrams from a database schema.
posted by Good Brain at 9:11 AM on January 26, 2011

Try EasyDB http://ceeasydb.sourceforge.net/. Toad Modeler 3 also has a feature, but not sure on the limitations of the freeware version.

Note: I haven't used these tools myself, but both tools appear very safe, since one of them is hosted on sourceforge and the other is a very well know company. Just download from original locations.
posted by theobserver at 9:17 AM on January 26, 2011

sqlmaestro does this, also reverse engineers. I believe mysql had a workbench tool that did it as well.
posted by jenkinsEar at 10:09 AM on January 26, 2011

Are you using MySQL? It sounds like you are looking for MySQL Workbench.
posted by Dr Dracator at 10:59 AM on January 26, 2011

Dia2Sql
posted by empath at 11:01 AM on January 26, 2011