Tuesday, 8 July 2008

SQL Documentation Tool 7.8 for SQL Server

The SQL Documentation Tool is a complete documentation solution for Microsoft SQL Server databases. It automatically creates comprehensive technical documentation reports for databases, saving valuable developer time and money.

Reports are created in HTML [sample], Microsoft's HTML Help [sample], RTF [sample] and text [sample] formats. Color coded, syntax highlighted copies of the Transact SQL associated with stored procedures, functions and views are included with the reports. The compiled HTML Help reports includes an index and search facility.

Version 7.8 offers the following updates:

  • Object owners are now documented. The SQL Documentation Tool now documents the owners of objects. Note that there are fundamental changes between the way SQL Server 2005 and earlier versions handle users. In SQL Server 2000, database objects were owned by users. The four part reference to a database object in SQL Server 2000 is [DatabaseServer].[DatabaseName].[ObjectOwner].[DatabaseObject]. Beginning in SQL Server 2005, the four-part reference to a database object is [DatabaseServer].[DatabaseName].[DatabaseSchema].[DatabaseObject]. For more details of these changes visit http://msdn2.microsoft.com/en-us/library/ms190387.aspx. Note that when documenting SQL Server 2005 databases, the SQL Documentation Tool will add any objects that aren't assigned a schema to the default 'dbo' schema. The SQL Documentation Tool retains the capability to document database servers prior to SQL Server 2005.

  • Table column descriptions are now extracted from SQL Server 2005 databases.

  • Databases objects with single quotes in them are now correctly documented (although it's not recommended you use them).

  • Database, stored procedure, table, table trigger and view descriptions are now extracted from SQL Server 2005 databases and displayed in the HTML and HTML Help format reports.

  • SQL Server 2005 relationships are now correctly documented.

  • The project option Use table column descriptions has been renamed Use MS_Description Extended Properties.

Download the SQL Documentation Tool Trial VersionDownload SQL Documentation Tool Trial Version