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) 6 users marked this as a favorite
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


« Older Help me find new mystery authors.   |   Get outta town. Newer »
This thread is closed to new comments.