Database diagram -> sql
January 26, 2011 8:58 AM Subscribe
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?
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?
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
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
posted by jenkinsEar at 10:09 AM on January 26, 2011
Best answer: 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
posted by Dr Dracator at 10:59 AM on January 26, 2011
This thread is closed to new comments.
posted by Good Brain at 9:11 AM on January 26, 2011