Graphical Mapping a Database

[Tim Edwards]

I have been request to create a relational database map that can be place on
the wall in my office. Generally I done these in the past by just manually
typing the information into Access and then printing a map from there.
However the database they want mapped has a couple dozen tables in it and I
don't relish the idea of entering all that by hand. Nor do I relish the idea
of sitting down and writing one a program to automaticly do it if there one
aviaiable.

Does anyone have a utility to map out database structures and put it in a
printable format ? PDF, GIF, JPG, etc.

__________________________________________________ _______________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

[David Fetter]

"Tim Edwards" <mo*****@hotmail.com> wrote:

I have been request to create a relational database map that can be
place on the wall in my office. Generally I done these in the past
by just manually typing the information into Access and then
printing a map from there. However the database they want mapped
has a couple dozen tables in it and I don't relish the idea of
entering all that by hand. Nor do I relish the idea of sitting down
and writing one a program to automaticly do it if there one
aviaiable.

Does anyone have a utility to map out database structures and put it
in a printable format ? PDF, GIF, JPG, etc.

Try DBVisualizer at <http://www.minq.se/>.

HTH :)

Cheers,
D
--
David Fetter da***@fetter.org http://fetter.org/
phone: [phone] cell: [phone]

Everyone who lives, dies. Not everyone who dies has ever lived.

[Ron Johnson]

On Thu, 2003-08-14 at 23:17, David Fetter wrote:

"Tim Edwards" <mo*****@hotmail.com> wrote:

I have been request to create a relational database map that can be
place on the wall in my office. Generally I done these in the past
by just manually typing the information into Access and then
printing a map from there. However the database they want mapped
has a couple dozen tables in it and I don't relish the idea of
entering all that by hand. Nor do I relish the idea of sitting down
and writing one a program to automaticly do it if there one
aviaiable.

Does anyone have a utility to map out database structures and put it
in a printable format ? PDF, GIF, JPG, etc.

Try DBVisualizer at <http://www.minq.se/>.

There's also AutoDoc http://www.rbt.ca/autodoc/index.html which can
output to a dia-compatible format.

+---------------------------------------------------------------+
| Ron Johnson, Jr. Home: ro***********@cox.net |
| Jefferson, LA USA |
| |
| "Man, I'm pretty. Hoo Hah!" |
| Johnny Bravo |
+---------------------------------------------------------------+

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

[Jeffrey Melloy]

If you don't mind spending a little money and are on Windows, you can
use Microsoft Visio Professional.

On Saturday, August 16, 2003, at 01:38 AM, Ron Johnson wrote:

On Thu, 2003-08-14 at 23:17, David Fetter wrote:

"Tim Edwards" <mo*****@hotmail.com> wrote:

I have been request to create a relational database map that can be
place on the wall in my office. Generally I done these in the past
by just manually typing the information into Access and then
printing a map from there. However the database they want mapped
has a couple dozen tables in it and I don't relish the idea of
entering all that by hand. Nor do I relish the idea of sitting down
and writing one a program to automaticly do it if there one
aviaiable.

Does anyone have a utility to map out database structures and put it
in a printable format ? PDF, GIF, JPG, etc.

Try DBVisualizer at <http://www.minq.se/>.

There's also AutoDoc http://www.rbt.ca/autodoc/index.html which can
output to a dia-compatible format.

+---------------------------------------------------------------+
| Ron Johnson, Jr. Home: ro***********@cox.net |
| Jefferson, LA USA |
| |
| "Man, I'm pretty. Hoo Hah!" |
| Johnny Bravo |
+---------------------------------------------------------------+

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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Christopher Murtagh]

On Fri, 2003-08-15 at 00:17, David Fetter wrote:

"Tim Edwards" <mo*****@hotmail.com> wrote:

Does anyone have a utility to map out database structures and put it
in a printable format ? PDF, GIF, JPG, etc.

Try DBVisualizer at <http://www.minq.se/>.

FWIW, we bought a site license for DBVis and it has been pretty great.
It runs on my YellowDog Linux (PPC) and RedHat desktops as well as our
MacOS X machines. Well worth the $$ IMO.

Cheers,

Chris

--
Christopher Murtagh
Enterprise Systems Administrator
ISR / Web Communications Group
McGill University
Montreal, Quebec
Canada

Tel.: [phone]
Fax: [phone]

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend