Thread: importing pgsql schema into visio (for diagramming)
Does anyone know where I could find a tool which allows importing schema information from a postgres database into visio? The boss guys want some pretty pictures...
Andrew
Andrew
On Wed, Sep 12, 2007 at 04:32:22PM -0700, Andrew Hammond wrote: > Does anyone know where I could find a tool which allows importing > schema information from a postgres database into visio? The boss > guys want some pretty pictures... I'm pretty sure VisioPro has a way to attach to databases via ODBC and/or .NET. Cheers, David. -- David Fetter <david@fetter.org> http://fetter.org/ phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter Remember to vote! Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
On Sep 12, 2007, at 4:32 PM, Andrew Hammond wrote: > Does anyone know where I could find a tool which allows importing > schema information from a postgres database into visio? The boss > guys want some pretty pictures... Visio has that built-in for a long time - point it at the database via ODBC and let it go. Cheers, Steve
Helllo, you can also look at Case Studio, this software have a nice reverse engineering functionnality! Good luck Bruno Lavoie Andrew Hammond a écrit : > Does anyone know where I could find a tool which allows importing > schema information from a postgres database into visio? The boss guys > want some pretty pictures... > > Andrew
On Wed, 12 Sep 2007 23:32:24 -0400 Bruno Lavoie <bruno.lavoie@gmail.com> wrote: > Helllo, > > you can also look at Case Studio, this software have a nice reverse > engineering functionnality! > > Good luck > Bruno Lavoie > > Andrew Hammond a écrit : > > Does anyone know where I could find a tool which allows importing > > schema information from a postgres database into visio? The boss > > guys want some pretty pictures... dbvisualizer does a nice job reverse engineering schemas (assuming the fk's are defined, NOT implied) :) http://www.dbvis.com/products/dbvis/ Here's a sample: http://www.smcing.com/images/pb_schema.jpg Josh
On Wed, 12 Sep 2007 23:32:24 -0400
Bruno Lavoie <bruno.lavoie@gmail.com> wrote:
> you can also look at Case Studio, this software have a nice reverse
> engineering functionnality!
hear hear - great little tool
_________________________
{Beto|Norberto|Numard} Meijome
"A tyrant...is always stirring up some war or other, in order that the people may require a leader."
Plato
I speak for myself, not my employer. Contents may be hot. Slippery when wet. Reading disclaimers makes you go blind.
Writingthem is worse. You have been Warned.
Hi list, Le jeudi 13 septembre 2007, Andrew Hammond a écrit : > Does anyone know where I could find a tool which allows importing schema > information from a postgres database into visio? The boss guys want some > pretty pictures... Druid[1] is somewhat capable of delivering nice pictures out of an existing database, though not on an automated way --- you have to import each table one by one then sketch the schema out of this yourself, only linking of tables is automatic. But the advantage not found on other tools is its ability to create as much E/R views as needed, with whatever tables set on them (same table on several E/R views is possible). This allows for hand-crafting nice part picture to print, each one corresponding to a logical part of the database instead of what was easy to print out on some A4/letter pages. For fully automatic processing, you can also try SchemaSpy[2] which is ok for online browsing the schema, but not so much for dead-tree form. [1] http://druid.sourceforge.net/ [2] http://schemaspy.sourceforge.net/ Hope this helps, regards, -- dim
Attachment
On Sep 12, 2007, at 7:32 PM, Andrew Hammond wrote: > Does anyone know where I could find a tool which allows importing > schema information from a postgres database into visio? The boss > guys want some pretty pictures... > See SQLFairy. it can generate pretty pictures directly from the schemas. I also have some script somewhere that generates graphviz output which makes optimal graphs.