Thread: 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
> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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)
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 >
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
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
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
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)