Thread: Visual display tool?

Visual display tool?

From
"Oberpriller, Wade D."
Date:
Can anyone recommend a visual display tool to create a picture (i.e. table
layouts and relationships) of my database? Pictures are worth a thousand
words.

Wade Oberpriller                 http://www.storagetek.com
Software Development             Phone: (763) 424-1538
StorageTek: MRDC                        (800) 328-9108 ext. 1538
wade_oberpriller@storagetek.com  Fax:   (763) 391-1095

Re: Visual display tool?

From
Herbert Liechti
Date:
  > Can anyone recommend a visual display tool to create a picture (i.e. table
  > layouts and relationships) of my database? Pictures are worth a thousand
  > words.

We are using the GraphViz  Perl library which is a very handy
tool for automatic drawings of relationsships. GraphViz available
from CPAN depends on the libraries from graphviz.org.

best regards
Herbie

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti                                  http://www.thinx.ch
ThinX networked business services    Adlergasse 5, CH-4500 Solothurn
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Re: Visual display tool?

From
"Peter Darley"
Date:
Wade,
    Probably won't be a hit here, since it's not open source, and is indeed
owned by Microsoft, but Visio does an excellent job of this.  Using an ODBC
connection it can decompile a database, draw out foreign key relations, etc.
Very slick.
Thanks,
Peter D.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Oberpriller,
Wade D.
Sent: Tuesday, March 19, 2002 7:43 AM
To: PostgreSQL General Help (E-mail)
Subject: [GENERAL] Visual display tool?


Can anyone recommend a visual display tool to create a picture (i.e. table
layouts and relationships) of my database? Pictures are worth a thousand
words.

Wade Oberpriller                 http://www.storagetek.com
Software Development             Phone: (763) 424-1538
StorageTek: MRDC                        (800) 328-9108 ext. 1538
wade_oberpriller@storagetek.com  Fax:   (763) 391-1095

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


Re: Visual display tool?

From
"Carlo Florendo"
Date:
Have you heard of MyErd?  It's a windows based app but it could make a diagram out of your DB schema.
It's pretty basic however (e.g. it recognizes relationships only if the fields being related on the 2 or more tables
havethe same 
name).  If you want a copy, email me privately.

Best Regards,

Carlo Florendo
NEC Telecoms
fcarlo@ntsp.nec.co.jp


----- Original Message -----
From: "Peter Darley" <pdarley@kinesis-cem.com>
To: "Oberpriller, Wade D." <oberpwd@nsc-msg01.network.com>; "PostgreSQL General Help (E-mail)"
<pgsql-general@postgresql.org>
Sent: Tuesday, March 19, 2002 1:41 PM
Subject: Re: [GENERAL] Visual display tool?


> Wade,
> Probably won't be a hit here, since it's not open source, and is indeed
> owned by Microsoft, but Visio does an excellent job of this.  Using an ODBC
> connection it can decompile a database, draw out foreign key relations, etc.
> Very slick.
> Thanks,
> Peter D.
>
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Oberpriller,
> Wade D.
> Sent: Tuesday, March 19, 2002 7:43 AM
> To: PostgreSQL General Help (E-mail)
> Subject: [GENERAL] Visual display tool?
>
>
> Can anyone recommend a visual display tool to create a picture (i.e. table
> layouts and relationships) of my database? Pictures are worth a thousand
> words.
>
> Wade Oberpriller                 http://www.storagetek.com
> Software Development             Phone: (763) 424-1538
> StorageTek: MRDC                        (800) 328-9108 ext. 1538
> wade_oberpriller@storagetek.com  Fax:   (763) 391-1095
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>


Re: Visual display tool?

From
"Tom Pfau"
Date:
Yeah, Visio can reverse engineer your database and make a pretty picture
but it doesn't support PostgreSQL very well for generating a database.
It loses any foreign key constraint options (ON DELETE, ON UPDATE) that
you might set.  It's also a pig (takes several minutes to load our
database diagram of about 50 tables).  We're evaluating Data Architect
(http://www.theKompany.com/).

-----Original Message-----
From: Peter Darley [mailto:pdarley@kinesis-cem.com]
Sent: Tuesday, March 19, 2002 4:42 PM
To: Oberpriller, Wade D.; PostgreSQL General Help (E-mail)
Subject: Re: [GENERAL] Visual display tool?


Wade,
    Probably won't be a hit here, since it's not open source, and is
indeed
owned by Microsoft, but Visio does an excellent job of this.  Using an
ODBC
connection it can decompile a database, draw out foreign key relations,
etc.
Very slick.
Thanks,
Peter D.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Oberpriller,
Wade D.
Sent: Tuesday, March 19, 2002 7:43 AM
To: PostgreSQL General Help (E-mail)
Subject: [GENERAL] Visual display tool?


Can anyone recommend a visual display tool to create a picture (i.e.
table
layouts and relationships) of my database? Pictures are worth a thousand
words.

Wade Oberpriller                 http://www.storagetek.com
Software Development             Phone: (763) 424-1538
StorageTek: MRDC                        (800) 328-9108 ext. 1538
wade_oberpriller@storagetek.com  Fax:   (763) 391-1095

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Re: Visual display tool?

From
"Peter Darley"
Date:
Tom,
    I found that DataArchitect crashes every windows machine I installed it on.
I assume that it works correctly on Linux, but installing anything with
dependencies in Linux is far more work than I can deal with (My life would
probably be better if I weren't so lazy).
Thanks,
Peter Darley

-----Original Message-----
From: Tom Pfau [mailto:T.Pfau@emCrit.com]
Sent: Wednesday, March 20, 2002 6:44 AM
To: Peter Darley; Oberpriller, Wade D.; PostgreSQL General Help (E-mail)
Subject: RE: [GENERAL] Visual display tool?


Yeah, Visio can reverse engineer your database and make a pretty picture
but it doesn't support PostgreSQL very well for generating a database.
It loses any foreign key constraint options (ON DELETE, ON UPDATE) that
you might set.  It's also a pig (takes several minutes to load our
database diagram of about 50 tables).  We're evaluating Data Architect
(http://www.theKompany.com/).

-----Original Message-----
From: Peter Darley [mailto:pdarley@kinesis-cem.com]
Sent: Tuesday, March 19, 2002 4:42 PM
To: Oberpriller, Wade D.; PostgreSQL General Help (E-mail)
Subject: Re: [GENERAL] Visual display tool?


Wade,
    Probably won't be a hit here, since it's not open source, and is
indeed
owned by Microsoft, but Visio does an excellent job of this.  Using an
ODBC
connection it can decompile a database, draw out foreign key relations,
etc.
Very slick.
Thanks,
Peter D.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Oberpriller,
Wade D.
Sent: Tuesday, March 19, 2002 7:43 AM
To: PostgreSQL General Help (E-mail)
Subject: [GENERAL] Visual display tool?


Can anyone recommend a visual display tool to create a picture (i.e.
table
layouts and relationships) of my database? Pictures are worth a thousand
words.

Wade Oberpriller                 http://www.storagetek.com
Software Development             Phone: (763) 424-1538
StorageTek: MRDC                        (800) 328-9108 ext. 1538
wade_oberpriller@storagetek.com  Fax:   (763) 391-1095

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


Re: Visual display tool?

From
"Tom Pfau"
Date:
Although Data Architect has crashed on me a few times, it has not done
anything to destabilize W2K.  I haven't checked out the linux version
yet.

-----Original Message-----
From: Peter Darley [mailto:pdarley@kinesis-cem.com]
Sent: Wednesday, March 20, 2002 9:44 AM
To: Tom Pfau; Oberpriller, Wade D.; PostgreSQL General Help (E-mail)
Subject: RE: [GENERAL] Visual display tool?


Tom,
    I found that DataArchitect crashes every windows machine I
installed it on.
I assume that it works correctly on Linux, but installing anything with
dependencies in Linux is far more work than I can deal with (My life
would
probably be better if I weren't so lazy).
Thanks,
Peter Darley

-----Original Message-----
From: Tom Pfau [mailto:T.Pfau@emCrit.com]
Sent: Wednesday, March 20, 2002 6:44 AM
To: Peter Darley; Oberpriller, Wade D.; PostgreSQL General Help (E-mail)
Subject: RE: [GENERAL] Visual display tool?


Yeah, Visio can reverse engineer your database and make a pretty picture
but it doesn't support PostgreSQL very well for generating a database.
It loses any foreign key constraint options (ON DELETE, ON UPDATE) that
you might set.  It's also a pig (takes several minutes to load our
database diagram of about 50 tables).  We're evaluating Data Architect
(http://www.theKompany.com/).

-----Original Message-----
From: Peter Darley [mailto:pdarley@kinesis-cem.com]
Sent: Tuesday, March 19, 2002 4:42 PM
To: Oberpriller, Wade D.; PostgreSQL General Help (E-mail)
Subject: Re: [GENERAL] Visual display tool?


Wade,
    Probably won't be a hit here, since it's not open source, and is
indeed
owned by Microsoft, but Visio does an excellent job of this.  Using an
ODBC
connection it can decompile a database, draw out foreign key relations,
etc.
Very slick.
Thanks,
Peter D.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Oberpriller,
Wade D.
Sent: Tuesday, March 19, 2002 7:43 AM
To: PostgreSQL General Help (E-mail)
Subject: [GENERAL] Visual display tool?


Can anyone recommend a visual display tool to create a picture (i.e.
table
layouts and relationships) of my database? Pictures are worth a thousand
words.

Wade Oberpriller                 http://www.storagetek.com
Software Development             Phone: (763) 424-1538
StorageTek: MRDC                        (800) 328-9108 ext. 1538
wade_oberpriller@storagetek.com  Fax:   (763) 391-1095

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


Re: Visual display tool?

From
"Rob Storrs"
Date:
DbVisualizer is a free tool available at http://www.minq.se/products/dbvis.
It uses jdbc, so you can connect to any type of database for which you can
find a jdbc driver.

~Rob Storrs

"Oberpriller, Wade D." <oberpwd@nsc-msg01.network.com> wrote in message
news:mailman.1016553001.9673.pgsql-gen@basebeans.com...
> Can anyone recommend a visual display tool to create a picture (i.e. table
> layouts and relationships) of my database? Pictures are worth a thousand
> words.
>
> Wade Oberpriller                 http://www.storagetek.com
> Software Development             Phone: (763) 424-1538
> StorageTek: MRDC                        (800) 328-9108 ext. 1538
> wade_oberpriller@storagetek.com  Fax:   (763) 391-1095
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)