Обсуждение: Graphical Mapping a Database
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
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 ~
"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/>. 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.
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/>. 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 | +---------------------------------------------------------------+
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" <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/>. > > 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)
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/>. > > > > 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 | +---------------------------------------------------------------+
The difference between "my money" and "my work's money". :) On Saturday, August 16, 2003, at 03:09 AM, Ron Johnson wrote: > 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/>. >>> >>> 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
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 :-)
There is also Dezign for Databases, http://www.datanamic.com/ Tino Wildenhain wrote: > 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 >
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/>. 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