best er modeling tool for postgreSQL

I've played about with DIA and the transform tool I can't remember the
name of right no that takes DIA input and creates DDL commands. not
bad.

But I keep coming back to a big white board... :)

Enrico SABBADIN, 20.05.2008 15:13:

Hi, I�m evaluating different er modeling tools .. I have to support the
same logical db on postgresql and sqlserver ..

All tools I tried so far ignore the schema information .. all tables end
up living in the default schema.

Have a look at Power*Architect it's OpenSource and free. I have played around with it a bit and it looks quite nice. You can define a schema when creating the DDL

http://www.sqlpower.ca/page/architect

Printing is a pain though (doesn't remember page settings, but the print out is OK)

Regards
Thomas

Thanks for posting this. I had been using DB Designer 4 which has tons
of bugs in it. Power Architect is pretty nice.

Jon

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-
owner@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Wednesday, May 21, 2008 2:01 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] best er modeling tool for postgreSQL

Enrico SABBADIN, 20.05.2008 15:13:

Hi, I'm evaluating different er modeling tools .. I have to support

the

same logical db on postgresql and sqlserver ..

All tools I tried so far ignore the schema information .. all tables

end

up living in the default schema.

Have a look at Power*Architect it's OpenSource and free. I have played
around with it a bit and it looks quite nice. You can define a schema

when

creating the DDL

http://www.sqlpower.ca/page/architect

Printing is a pain though (doesn't remember page settings, but the

print

I don't remember if MagicDraw supports multiple schema or not, but back when
I was looking at CASE-type tools it was one the nicer ones that I found that
would run on platforms other than Windows.

--
Scott Ribe
scott_ribe@killerbytes.com
http://www.killerbytes.com/
(303) 722-0567 voice

Scott Ribe wrote:

I don't remember if MagicDraw supports multiple schema or not, but back when
I was looking at CASE-type tools it was one the nicer ones that I found that
would run on platforms other than Windows.

For Windows, I've been using Case Studio for several years and I've been
very happy with it. However, the company has since been bought by Quest
and the product name was changed to Toad Data Modeler. I have no idea
if it's the same as or /better/worse than CS.

I know some of these have already been mentioned, but here's the summary I had
stashed away. Although, I'm not sure which ones have any issues with default
schemas. If you do find any such problems (especially with the kind GPL
developers), I'm sure they'd appreciate any feedback.

/** GNU-GPL **/
OpenSystemArchitect
http://www.codebydesign.com/
Power*Architect
http://code.google.com/p/power-architect/
Druid
http://druid.sourceforge.net/
ERW
http://erw.dsi.unimi.it/
Dia
http://live.gnome.org/Dia
XML to DDL (python scripts)
http://xml2ddl.berlios.de/
Graphiz - I believe I've read of people using it to reverse engineer from DDL
http://graphviz.org/

/** Multiple versions/licenses (each has a "free" and a "not-free" version) **/
DBVisualizer
http://www.minq.se/products/dbvis/
Toad
http://www.toadsoft.com/

/** Not-free **/
Microsoft Visio - (If you already have it, it does work quite well)
DataStudio - 30 day trial
http://www.aquafold.com
DBWrench - 30 day trial
http://www.dbwrench.com/

jcvlz wrote on 25.05.2008 04:41:

/** Not-free **/
Microsoft Visio - (If you already have it, it does work quite well)
DataStudio - 30 day trial
http://www.aquafold.com
DBWrench - 30 day trial
http://www.dbwrench.com/

There are some more non-free ones (although Windows only)

DeZign: http://www.datanamic.com/dezign/index.html
HappyFish: http://www.polderij.nl/happyfish/products.html
DDS-Pro: http://www.dds-pro.com/
dbConstructor: http://www.dbconstructor.com/home/home.aspx

All are priced in the range �150 to �350

I had (a quick) look at them, and DeZign looks quite nice. It is more feature
richt than Power*Architect especially when it comes to a full-blown round-trip
engineering and it can reverse engineer a model from SQL scripts (haven't tested
that with PG scripts though).
I also like the ability to create sub-models which keeps larger models clean.

Thomas