Documenting Schema

[MSPJ]

Hi - I'm not sure if this is the right forum for this question, but I couldn't find an obvious candidate. I'm sure someone will move it if there's a better choice.

I'm trying to figure out a good system to use for documenting my database. The graphical relationship diagram is not the easiest to use for documenting how things are set up. I've tried to use background "notes" with text to describe branches, etc - but that doesn't allow for a lot of detail in describing how things are set up.

I'm wondering if anyone has used any other tools for this purpose (eg Visio. DB Designer, MySql, etc) or could suggest approaches or links to threads on the topic? (I did search for "documentation" in the forums and didn't come up with much).

Thanks for your help.

Michael

[PathGeek]

Are we assuming you have tried the Database Design Report under the Tools bar.....?

[MSPJ]

Yup, I'm aware of the DDR, but that doesn't allow me to freely document what I'm doing and why I'm doing it. Looking for something to complement it. There are several tools such as Visio for Enterprise Architects that seem to provide the functions, but they seem like overkill as they're intended to actually interface with an SQL database and produce code.