SQL Server Documentation Tools

By: Greg Robidoux   |   Updated: 2019-03-28   |   Comments (19)   |   Related: > Tools

Problem

Maintaining documentation about your SQL Server databases is a big task.  No matter how many developers or DBAs you may have, keeping documentation current is a challenge.  In most cases you only need view a portion of the database defined in an easy to view format, but if this is something you don't keep up with on a constant basis your efforts will never yield up to the minute documentation.  In addition, SQL Server stores all kinds of meta data about your database objects, so it makes sense to utilize this data since it is easily accessible.  You could take the time to write queries and reports, but why bother when there are so many documentation products already available.

Solution

There are so many different products on the market for all different aspects of SQL Server and SQL Server documentation tools is another one of those product segments.  I knew there were a few tools that existed, but once I started digging in and searching the internet I was surprised to find so many tools.

These tools allow you to document your database from top to bottom in various formats CHM, HTML, XML, PDF, etc.  In addition, these tools create built-in hyperlinks for easy navigation through your database structures.  To build the documentation there is not much that needs to be done; a couple options to set and then a click to generate the files.

The cost of these tools starts around $99.

Here is a list of tools based on different components of SQL Server where you may want to generate documentation.  The tools are listed in no particular order.

Database Documentation

• ApexSQL Doc (see sample)
• Dataedo
• DTM Schema Reporter (see samples)
• dbdesc (see sample)
• DBScribe 1.4 for SQL Server (download samples)
• Document! X (no longer available)
• DOC xPress
• LiveDoco (no longer available)
• Red-Gate's SQL Doc (see demo)
• SchemaToDoc (see sample)
• SQLDocKit (no longer available)
• SqlSpec (see samples)
• SQL Data Dictionary
• SQLDoc
• SQL Documentation Tool (no longer available)
• SQL Help Builder (no longer available)
• T-SQL Source Code Unscrambler
• turtle SQL

Analysis Services Documentation

• DOC xPress

Reporting Services Documentation

• DOC xPress

Integration Services Documentation

• DOC xPress
• SSIS Documenter (no longer available)

DTS Documentation

• dtsdoc (see sample)
• DTS Documenter (no longer available)

Infrastructure Documentation

• XIA Configuration

Next Steps

• If you have the need to generate documentation for your SQL Server components take a look at these tools to see if they meet your needs.
• If you come across additional tools that generate documentation for SQL Server, please send to [email protected], so we can add them to the list.

About the author

Greg Robidoux is the President and founder of Edgewood Solutions, a technology services company delivering services and solutions for Microsoft SQL Server. He is also one of the co-founders of MSSQLTips.com. Greg has been working with SQL Server since 1999, has authored numerous database-related articles, and delivered several presentations related to SQL Server. Before SQL Server, he worked on many data platforms such as DB2, Oracle, Sybase, and Informix.

This author pledges the content of this article is based on professional experience and not AI generated.

View all my tips