We use Document! X from Innovasys and it works well for us.
Document! X is a documentation tool designed to parse the structure of
a database (or Visual Basic project or COM object), read comments
attached to the objects in the database, and then create on the fly
HTML help files. It creates help pages for each object in a database:
tables, views, triggers, and stored procedures. By tagging comments
within database objects like stored procedures or views, the developer
or documentation specialist can use the tool to copy those comments and
place them in appropriate locations on a help page automatically. A
similar process occurs with tables. When you create a new table using
SQL Enterprise Manager or Visual Studio .NET, you have the option of
writing a brief description for each table column (in addition to
assigning data types, lengths, and other data features). Document! X
looks for these comments, copies them, and then writes them to the help
file.
HTH,
Vishal
fireball wrote:
is there any documentation generating tool for SqlServer? (like pldoc for
Oracle)?
