Thread: best er modeling tool for postgreSQL
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
Can you fly that thing ?
Not Yet (The Matrix)
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