Обсуждение: 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...  :)

On Tue, May 20, 2008 at 7:13 AM, Enrico SABBADIN <Enrico.Sabbadin@wki.it> wrote:
> 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.
>
>
>
> What can you suggest ? thank you
>
>
>
> PLS: reply directly as well
>
> Best regards
>
>
>
> Enrico Sabbadin
>
> enrico.sabbadin@wki.it
>
>
>
> Can you fly that thing ?
>
> Not Yet (The Matrix)
>
>

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.
Youcan 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
> out is OK)
>
> Regards
> Thomas
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

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