Thread: GUI ERD/ERM tools?

GUI ERD/ERM tools?

From
Lou Picciano
Date:
Friends, 

This question from our users keeps coming up...

What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the need.

Can any of you recommend specific tools, preferences, etc?

Regards,  Lou Picciano

Re: GUI ERD/ERM tools?

From
Thomas Kellerer
Date:
Lou Picciano, 12.11.2010 15:40:
> Friends,
>
> This question from our users keeps coming up...
>
> What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the
need.
>
> Can any of you recommend specific tools, preferences, etc?
>
> Regards, Lou Picciano

If you are looking for a commercial tool, dbWrench is pretty good and reasonably priced.

The only usable open source/free tool that I know of is PowerArchitect

Regards
Thomas


Re: GUI ERD/ERM tools?

From
"Mark Felder"
Date:
On Fri, 12 Nov 2010 08:40:54 -0600, Lou Picciano <loupicciano@comcast.net>
wrote:

>
> What tools are each of you using for ERD ERM? pgAmin's Graphical Query
> Builder is helpful, but doesn't address the need.
>

I'm not a database guru and I'm not 100% clear on "ERD ERM", but I will
try to help anyway :)

I used to work at an Oracle-heavy shop and the preference for the DBAs and
developers was a tool called TOAD. You can find this software at
http://toadworld.com/. It doesn't seem to be well known outside of the
Oracle circles, but if their support for Postgres is half as good as their
support for Oracle I think you would find it to be an amazing tool for
visualizing the database, building queries, etc.

Good luck!


Regards,


Mark

Re: GUI ERD/ERM tools?

From
Viktor Bojović
Date:

On Fri, Nov 12, 2010 at 3:40 PM, Lou Picciano <loupicciano@comcast.net> wrote:
Friends, 

This question from our users keeps coming up...

What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder is helpful, but doesn't address the need.

Can any of you recommend specific tools, preferences, etc?

Regards,  Lou Picciano


i prefer EMS postgre manager. but it is not free

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me

Re: GUI ERD/ERM tools?

From
Dinesh Bhandary
Date:
I've used eclipse with clay ( plugin) in the past, it is pretty good.
And it is free,.

Dinesh
On 11/12/2010 8:07 AM, Mark Felder wrote:
> On Fri, 12 Nov 2010 08:40:54 -0600, Lou Picciano
> <loupicciano@comcast.net> wrote:
>
>>
>> What tools are each of you using for ERD ERM? pgAmin's Graphical
>> Query Builder is helpful, but doesn't address the need.
>
> I'm not a database guru and I'm not 100% clear on "ERD ERM", but I
> will try to help anyway :)
>
> I used to work at an Oracle-heavy shop and the preference for the DBAs
> and developers was a tool called TOAD. You can find this software at
> http://toadworld.com/. It doesn't seem to be well known outside of the
> Oracle circles, but if their support for Postgres is half as good as
> their support for Oracle I think you would find it to be an amazing
> tool for visualizing the database, building queries, etc.
>
> Good luck!
>
>
> Regards,
>
>
> Mark
>


Re: GUI ERD/ERM tools?

From
Dinesh Bhandary
Date:
I've used eclipse with clay (plugin) in the past and it is good. It is
free.


Dinesh

On Nov 12, 2010 06:46 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:

>Lou Picciano, 12.11.2010 15:40:
>>Friends,
>>
>>This question from our users keeps coming up...
>>
>>What tools are each of you using for ERD ERM? pgAmin's Graphical Query
>>Builder is helpful, but doesn't address the need.
>>
>>Can any of you recommend specific tools, preferences, etc?
>>
>>Regards, Lou Picciano
>
>If you are looking for a commercial tool, dbWrench is pretty good and
>reasonably priced.
>
>The only usable open source/free tool that I know of is PowerArchitect
>
>Regards
>Thomas
>
>
>
>--
>Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-admin
>
>


Re: GUI ERD/ERM tools?

From
Chris Browne
Date:
loupicciano@comcast.net (Lou Picciano) writes:
> This question from our users keeps coming up...
>
> What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder
> is helpful, but doesn't address the need.
>
> Can any of you recommend specific tools, preferences, etc?

I have tended to find that when doing design work, nothing is better for
the purposes of discussion of alternatives than a whiteboard and
markers.

Once the thinking has been done, I might use TCM to draft diagrams of
some of the relationships <http://wwwhome.cs.utwente.nl/~tcm/> to
compactly present them.

Once the thinking is stable enough to create tables, I like SchemaSpy
for providing diagramming that people can "click through" to examine the
relationships between tables.  <http://schemaspy.sourceforge.net/>
--
output = ("cbbrowne" "@" "gmail.com")
"Implying that you    can build systems  without  rigourous  interface
specification is always a powerful selling technique to the clueless."
-- Paul Campbell, seen in comp.object.corba

Re: GUI ERD/ERM tools?

From
Samuel Stearns
Date:
Another option is 'Database => Reverse Engineer' in Visio.

Sam

-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Chris Browne
Sent: Tuesday, 16 November 2010 3:06 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] GUI ERD/ERM tools?

loupicciano@comcast.net (Lou Picciano) writes:
> This question from our users keeps coming up...
>
> What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder
> is helpful, but doesn't address the need.
>
> Can any of you recommend specific tools, preferences, etc?

I have tended to find that when doing design work, nothing is better for
the purposes of discussion of alternatives than a whiteboard and
markers.

Once the thinking has been done, I might use TCM to draft diagrams of
some of the relationships <http://wwwhome.cs.utwente.nl/~tcm/> to
compactly present them.

Once the thinking is stable enough to create tables, I like SchemaSpy
for providing diagramming that people can "click through" to examine the
relationships between tables.  <http://schemaspy.sourceforge.net/>
--
output = ("cbbrowne" "@" "gmail.com")
"Implying that you    can build systems  without  rigourous  interface
specification is always a powerful selling technique to the clueless."
-- Paul Campbell, seen in comp.object.corba

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin