ERD tool

Hi,

I was just wondering if anyone could recommend a tool which allows the
user to create a new mysql database visually i.e. with an ERD - entity
relationship diagram? The visual representation is more important than
actually building the database in a GUI - I am familiar with the
command line or phpmyadmin etc.

The reason for asking is that I'm building a complex database from
scratch for the first time and think it would help me to conceptualise
the data if I can see it visually.

Also, would this forum be an appropriate place to post an ERD and get
feedback on the best way to do things? I do have some database
experience so would not be expecting people to build it for me

many thanks,

lukemack.

lukemack,

If you are looking for Open Source then you might want to try DBDesigner.
http://fabforce.net/dbdesigner4/

It is somewhat limited and a little cumbersome. If you can pay for it, then
the following are all good products:

Quest Toad Modeler
Sybase Power Designer
Embarcadero (I forget the name of their ERD product).

-- Bill

"lukemack" <lukemstore@gmail.com> wrote in message
news:1170181594.941602.187530@l53g2000cwa.googlegr oups.com...
> Hi,
>
> I was just wondering if anyone could recommend a tool which allows the
> user to create a new mysql database visually i.e. with an ERD - entity
> relationship diagram? The visual representation is more important than
> actually building the database in a GUI - I am familiar with the
> command line or phpmyadmin etc.
>
> The reason for asking is that I'm building a complex database from
> scratch for the first time and think it would help me to conceptualise
> the data if I can see it visually.
>
> Also, would this forum be an appropriate place to post an ERD and get
> feedback on the best way to do things? I do have some database
> experience so would not be expecting people to build it for me
>
> many thanks,
>
> lukemack.
>

Thanks - DBDesigner looks like the way forward.

On 30 Jan, 22:49, "AlterEgo" <altereg...@dslextreme.com> wrote:
> lukemack,
>
> If you are looking for Open Source then you might want to try DBDesigner.http://fabforce.net/dbdesigner4/
>
> It is somewhat limited and a little cumbersome. If you can pay for it, then
> the following are all good products:
>
> Quest Toad Modeler
> Sybase Power Designer
> Embarcadero (I forget the name of their ERD product).
>
> -- Bill
>
> "lukemack" <lukemst...@gmail.com> wrote in message
>
> news:1170181594.941602.187530@l53g2000cwa.googlegr oups.com...
>
>
>
>
>
> > Hi,
>
> > I was just wondering if anyone could recommend a tool which allows the
> > user to create a new mysql database visually i.e. with an ERD - entity
> > relationship diagram? The visual representation is more important than
> > actually building the database in a GUI - I am familiar with the
> > command line or phpmyadmin etc.
>
> > The reason for asking is that I'm building a complex database from
> > scratch for the first time and think it would help me to conceptualise
> > the data if I can see it visually.
>
> > Also, would this forum be an appropriate place to post an ERD and get
> > feedback on the best way to do things? I do have some database
> > experience so would not be expecting people to build it for me
>
> > many thanks,
>
> > lukemack.