Database Diagram Report

[Peter Hattam]

I am using Visio 2003 Professional to create a database diagram that I have
reverse engineered from an Oracle database. Is there a way to create a
report of the tables and the columns on each page?

Is there a way I can access the data using VB macros so that I can include
the information in a word document?

 

[Chris Roth [MVP]]

Hi Peter,

There's no published API for accessing the magic-data/structure behind a
Visio database diagram. I'm not sure if they store the solution data in some
sort of COM bit-bucket and hide it in a master, or bury it in Solution-XML
inside the document, yada, yada.

It may be possible for you to simply extract the data by reading the
structure of the shapes (ie: the text in each shape), but I'm not sure if
you'd want to obtain data that might not be shown in the shape...

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/

 

[Al Edlund]

You can use the tools => reports cotnrol for some of it. The database add-in
is a closed tool with an unpublished set of api's.
sorry,
al

 

[David Parker]

I believe that the Visio 2003 Enterprise Architect (part of Visual Studio
Enterprise 2005) includes data model reports (and forward engineering)