Documenting our Database and related processes

[KatCCH]

Our DBA wants better documentation of the database (using Visio 2007). In my
first attempt, I'm looking at a process that starts with a website. I'll be
documenting the swf file that is hosted, the web service and related web
config information, the web methods and SQL stored procedures being called
and the tables to be referenced...perhaps even to the level of making note of
primary and foreign keys within those tables, if necessary. He'd like this
documentation to go one step further, perhaps exporting it to a file or
another database where it can be queried. His ultimate goal is to know where
changes in one area of the database could adversly affect other areas.

I don't know which are the best templates/shapes to represent all of these
elements. I plan to use shape data for some of this documentation and then
export the data to it's final destination (a searchable database). Can
someone offer recommendations on how to best accomplish this? Thank you.

 

[Katch]

Visio CAN!
I have documented a process from user input on a website down to the tables
that are updated. Each shape has data attached that relates it to the other
process elements in the document. I have upload all the shape data to SQL
server where it can be queried to see how changing one element within a
process will affect other processes.