By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,514 Members | 748 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,514 IT Pros & Developers. It's quick & easy.

Graphical Mapping a Database

P: n/a
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

Nov 11 '05 #1
Share this Question
Share on Google+
4 Replies

P: n/a
"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: +1 510 893 6100 cell: +1 415 235 3778

Everyone who lives, dies. Not everyone who dies has ever lived.
Nov 11 '05 #2

P: n/a
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)

Nov 11 '05 #3

P: n/a
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

Nov 11 '05 #4

P: n/a
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.: (514) 398-3122
Fax: (514) 398-2017

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

Nov 11 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.