Page 1 of 1
Table design tools
Posted: Sat May 05, 2007 9:40 pm
by sentback
Do you know any table design tool? I'm not really sure if this is the right terminology but I need a tool just for doing a tables schema. You know... you first write down the table fields, see what works for you and what not... Can you recommend any software? Thanks
Posted: Sun May 06, 2007 7:50 pm
by Begby
Mysql has the workbench gui that does exactly what you are talking about
http://dev.mysql.com/doc/workbench/en/index.html
You can also use any number of UML tools to design a database schema and visualize it, or even something like Microsoft Visio.
Also you can use an old school approach where you just write down your entities, list what broad info you need about each one, then normalize it.
Posted: Mon May 07, 2007 3:17 am
by CoderGoblin
dbdesigner Was the inspiration for MySQL workbench. Last time I looked at Workbench wasn't in a fit state for use so I ended up reverting to the original dbdesigner. Not sure of the current status though.
Posted: Mon May 07, 2007 4:35 am
by onion2k
Workbench is still Alpha level, so I wouldn't recommend using it.
EDIT: I've downloaded this dbdesigner tool, seems to be pretty good. Connecting to a database took a couple of tries, but I've managed to get it to reverse engineer a small db and it figured out the relationships ok.. Really handy piece of kit.
Posted: Tue May 08, 2007 6:02 pm
by califdon
DBDesigner is pretty good, also you might want to look at DBTools Manager (
http://www.dbtools.com.br/), which I've found pretty useful.
Posted: Wed May 09, 2007 3:26 am
by CoderGoblin
DBTools Manager Free "Personal" Edition does not include the graphical database designer. I am also wary of anything that initially labels itself as
"DBManager Freeware/Standard Edition" and then when you go to download it states that it is "shareware".