Connecting Tech Pros Worldwide Forums | Help | Site Map

Graphical Mapping a Database

Tim Edwards
Guest
 
Posts: n/a
#1: Nov 11 '05
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 majordomo@postgresql.org


David Fetter
Guest
 
Posts: n/a
#2: Nov 11 '05

re: Graphical Mapping a Database


"Tim Edwards" <mor4321@hotmail.com> wrote:[color=blue]
> 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.[/color]

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

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.
Ron Johnson
Guest
 
Posts: n/a
#3: Nov 11 '05

re: Graphical Mapping a Database


On Thu, 2003-08-14 at 23:17, David Fetter wrote:[color=blue]
> "Tim Edwards" <mor4321@hotmail.com> wrote:[color=green]
> > 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.[/color]
>
> Try DBVisualizer at <http://www.minq.se/>.[/color]

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)

Jeffrey Melloy
Guest
 
Posts: n/a
#4: Nov 11 '05

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:
[color=blue]
> On Thu, 2003-08-14 at 23:17, David Fetter wrote:[color=green]
>> "Tim Edwards" <mor4321@hotmail.com> wrote:[color=darkred]
>>> 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.[/color]
>>
>> Try DBVisualizer at <http://www.minq.se/>.[/color]
>
> 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)[/color]


---------------------------(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
Guest
 
Posts: n/a
#5: Nov 11 '05

re: Graphical Mapping a Database


On Fri, 2003-08-15 at 00:17, David Fetter wrote:[color=blue]
> "Tim Edwards" <mor4321@hotmail.com> wrote:[color=green]
> > Does anyone have a utility to map out database structures and put it
> > in a printable format ? PDF, GIF, JPG, etc.[/color]
>
> Try DBVisualizer at <http://www.minq.se/>.[/color]

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

Closed Thread