Thread: graphical ERD tool

graphical ERD tool

From
Dennis Gearon
Date:
OK,
    I've given up on the tool I'm using. Anyone recommend a good,
graphical ERD CASE tool for postgres? I'm on windblowsXP.

Re: graphical ERD tool

From
"Dann Corbit"
Date:
> -----Original Message-----
> From: Dennis Gearon [mailto:gearond@fireserve.net]
> Sent: Friday, May 07, 2004 3:01 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] graphical ERD tool
>
>
> OK,
>     I've given up on the tool I'm using. Anyone recommend a good,
> graphical ERD CASE tool for postgres? I'm on windblowsXP.

What are you using?

I like ERWin/ERX, but it is not specifically tailored to PostgreSQL
(e.g. does not understand sequences, etc.).
So there are lots of manual steps after your bare SQL generation.

I could not get DBManager to work even with SQLite, but I think some
others like that one.

I downloaded Case Studio to try that, and also was unable even to
import.

I tried Visual Case 2, but that did not work for me, even though
PostgreSQL is listed as supported.

This looked real promising:
http://mogwai.sourceforge.net/
But when I try to reverse engineer PostgreSQL tables, the list of tables
is empty, even though the connection seems fine.

This is nowhere close to ready:
http://sourceforge.net/projects/pydbdesigner/

Don't bother:
http://sourceforge.net/projects/yadbd/

Re: graphical ERD tool

From
Dennis Gearon
Date:
I also like the looks of Mogwai. I am using Dezign, and it's OK. It used
to be better in the last version. NOW, it can't print anything more than
10 entities on my machine, and it's 1gig of ram/1.8ghz. It does a jpeg
in 0.1 second, so what it's printing problem I don't know.

Anyway, I am mostly interested in original design, but importation will
be some time in the future, I'm sure. I will look at Mogwai and hope
they get importation working soon.

ERWin looks really good, as does CASE2. However, CASE2 seems mostly for
maintenance and not origiinal design.

Dann Corbit wrote:

>>-----Original Message-----
>>From: Dennis Gearon [mailto:gearond@fireserve.net]
>>Sent: Friday, May 07, 2004 3:01 PM
>>To: pgsql-general@postgresql.org
>>Subject: [GENERAL] graphical ERD tool
>>
>>
>>OK,
>>    I've given up on the tool I'm using. Anyone recommend a good,
>>graphical ERD CASE tool for postgres? I'm on windblowsXP.
>>
>>
>
>What are you using?
>
>I like ERWin/ERX, but it is not specifically tailored to PostgreSQL
>(e.g. does not understand sequences, etc.).
>So there are lots of manual steps after your bare SQL generation.
>
>I could not get DBManager to work even with SQLite, but I think some
>others like that one.
>
>I downloaded Case Studio to try that, and also was unable even to
>import.
>
>I tried Visual Case 2, but that did not work for me, even though
>PostgreSQL is listed as supported.
>
>This looked real promising:
>http://mogwai.sourceforge.net/
>But when I try to reverse engineer PostgreSQL tables, the list of tables
>is empty, even though the connection seems fine.
>
>This is nowhere close to ready:
>http://sourceforge.net/projects/pydbdesigner/
>
>Don't bother:
>http://sourceforge.net/projects/yadbd/
>
>
>