Software to design Database

**Jacki** · 11-05-2009, 03:10 AM

Hi, I'm going to develope a big project and I need some useful tool, I'll work with a quite big database and I need a tool wich I can design tables relations etc.. Do you know any good software? Thanks.. bye!

**WingedPanther** · 11-05-2009, 09:00 AM

It will depend somewhat on the database type. There are different tools for different databases. It also depends on your price range.

**Jacki** · 11-05-2009, 11:58 AM

Uhmmm... I forgot to say that I'm looking for a free software. I'll work in mysql, my project will be php/mysql.

**WingedPanther** · 11-05-2009, 12:11 PM

There's a module in XAMPP for managing MySQL databases. PHPAdmin, I think.

**Orjan** · 11-05-2009, 01:36 PM

phpMyAdmin is for example in xampp and most other control panels.
I mainly use HeidiSQL for my database issues.
something for building relations etc, I don't have. But I guess you could use an UML tool as StarUML to make relation sketches, although, it has no connection to the sql.

Edit: I just looked around, and found that MySQL themselves has something they call MySQL Workbench which can let you create what you want. find it here: MySQL :: MySQL Workbench 5.1

**Jacki** · 11-05-2009, 02:16 PM

I think I expressed myself badly, I already know phpmyadmin because I've already used it and I'm now using it... I believe that StarUML is what I was searching... Thanks at all..

**PGP_Protector** · 11-05-2009, 02:59 PM

Originally Posted by Orjan

phpMyAdmin is for example in xampp and most other control panels.
I mainly use HeidiSQL for my database issues.
something for building relations etc, I don't have. But I guess you could use an UML tool as StarUML to make relation sketches, although, it has no connection to the sql.

Edit: I just looked around, and found that MySQL themselves has something they call MySQL Workbench which can let you create what you want. find it here: MySQL :: MySQL Workbench 5.1

I so love HeidiSQL, I use that for Work & Home.

**Natrobius** · 11-05-2009, 04:47 PM

I have used the workbench included with MySQL and have found it to be very full featured. Worth checking into.

**WingedPanther** · 11-06-2009, 09:12 AM

I haven't played with StarUML yet... how do you like it?

**Orjan** · 11-06-2009, 06:30 PM

I think it's ok for it's purpose, so if you are a RUP (Rational Unified Process) user, then it seems to be a great tool. we actually uses it at our University in our assignments and other stuff during system development courses