Graphical Mapping a Database

Started by Tim Edwardsover 22 years ago10 messagesgeneral
Jump to latest
#1Tim Edwards
mor4321@hotmail.com

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

#2Andre Truter
andre.truter@intekom.co.za
In reply to: Tim Edwards (#1)
Re: Graphical Mapping a Database

On Thu, 2003-08-14 at 21:49, Tim Edwards 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.

I have used DataArchitect to do that. It can reverse-engineer the
database and draw a physical model of the database.

http://www.thekompany.com

HTH
--

Andre Truter Software Engineer Registered Linux user #185282
ICQ #40935899 AIM: trusoftzaf http://www.trusoft.za.net

~ A dinosaur is a salamander designed to Mil Spec ~

#3David Fetter
shackle@fetter.org
In reply to: Tim Edwards (#1)
Re: Graphical Mapping a Database

"Tim Edwards" <mor4321@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/&gt;.

HTH :)

Cheers,
D
--
David Fetter david@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.

#4Ron Johnson
ron.l.johnson@cox.net
In reply to: David Fetter (#3)
Re: Graphical Mapping a Database

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

"Tim Edwards" <mor4321@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/&gt;.

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

+---------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net           |
| Jefferson, LA  USA                                            |
|                                                               |
| "Man, I'm pretty.  Hoo Hah!"                                  |
|    Johnny Bravo                                               |
+---------------------------------------------------------------+
#5Jeffrey Melloy
jmelloy@visualdistortion.org
In reply to: Ron Johnson (#4)
Re: Graphical Mapping a Database

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:

Show quoted text

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

"Tim Edwards" <mor4321@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/&gt;.

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

+---------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@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
majordomo@postgresql.org)

#6Ron Johnson
ron.l.johnson@cox.net
In reply to: Jeffrey Melloy (#5)
Re: Graphical Mapping a Database

On Sat, 2003-08-16 at 01:42, Jeffrey Melloy wrote:

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

The Force is strong in him, but he has strayed to the Dark Side.
Very surprising, since he uses a Mac...

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" <mor4321@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/&gt;.

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

-- 
+---------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net           |
| Jefferson, LA  USA                                            |
|                                                               |
| "Man, I'm pretty.  Hoo Hah!"                                  |
|    Johnny Bravo                                               |
+---------------------------------------------------------------+
#7Jeffrey Melloy
jmelloy@visualdistortion.org
In reply to: Ron Johnson (#6)
Re: Graphical Mapping a Database

The difference between "my money" and "my work's money". :)

On Saturday, August 16, 2003, at 03:09 AM, Ron Johnson wrote:

Show quoted text

On Sat, 2003-08-16 at 01:42, Jeffrey Melloy wrote:

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

The Force is strong in him, but he has strayed to the Dark Side.
Very surprising, since he uses a Mac...

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" <mor4321@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/&gt;.

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

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

---------------------------(end of
broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org

#8Tino Wildenhain
tino@wildenhain.de
In reply to: Jeffrey Melloy (#7)
Re: Graphical Mapping a Database

Hi,

Jeffrey Melloy wrote:

The difference between "my money" and "my work's money". :)

But Visio sucks anyway. If on Windows, there is also
casestudio (www.casestudio.com)
(seems to need some help for 7.3)

And it kinda works with wine also :-)

#9Dennis Gearon
gearond@cvc.net
In reply to: Tino Wildenhain (#8)
Re: Graphical Mapping a Database

There is also Dezign for Databases, http://www.datanamic.com/

Tino Wildenhain wrote:

Show quoted text

Hi,

Jeffrey Melloy wrote:

The difference between "my money" and "my work's money". :)

But Visio sucks anyway. If on Windows, there is also
casestudio (www.casestudio.com)
(seems to need some help for 7.3)

And it kinda works with wine also :-)

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

http://www.postgresql.org/docs/faqs/FAQ.html

#10Christopher Murtagh
christopher.murtagh@mcgill.ca
In reply to: David Fetter (#3)
Re: Graphical Mapping a Database

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

"Tim Edwards" <mor4321@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/&gt;.

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