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 SQL Documentation Tool Trial Version

SQL Documentation Tool 7.7 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.7 offers the following updates:

• Database Stored Procedures and Functions are now listed separately within the documentation; in previous versions of the SQL Documentation Tool they were all listed as Stored Procedures.


• The connection test functionality now warns if the connection test was not completely successful.


• The internal connection string builder functionality has been rewritten. Benefits to the end user include much better support for SQL Server 2005.


• The connection settings window has a database server type drop-down list. This ensures
  the full capabilities of SQL Server 2005 and above are utilised by the documentor.

Download SQL Documentation Tool Trial Version

SQL Documentation Tool 7.6 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.6 offers the following update:

• There is now an option to document dependency information for database tables, views, stored procedures and triggers. Note: Dependency information will not be shown for triggers unless database tables are documented. Documenting dependencies may significantly slow down the data extraction routines, particularly on very large databases.

Download SQL Documentation Tool Trial Version

SQL Documentation Tool 7.5

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.5 offers the following updates:

• The documentation has been revised.


• Added link on application's Help menu to http://www.softwaredocumentation.info/.


• The HTML format documentation includes a date and timestamp to show when the data was extracted and when the documentation was generated.

Download SQL Documentation Tool Trial Version

SQL Documentation Tool 7.4 for SQL Server

The SQL Documentation Tool is a complete documentation solution for Microsoft SQL Server 7.0, 2000 and 2005 databases. It automatically creates comprehensive technical documentation reports for databases, saving valuable developer/DBA 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 a comprehensive index and search facility.

Version 7.4 of the SQL Documentation Tool contains the following updates:

• Added a progress bar to the status panel which updates during both data extraction and documentation generation activities. Note that HTML Help compilation time can only be estimated.


• Corrected a typo on the Edit Database Connection window.


• All windows made modal within the graphical user interface, improving application usability.

Download SQL Documentation Tool Trial Version

SQL Documentation Tool 7.3 for SQL Server

The SQL Documentation Tool is a complete database documentor 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.3 offers the following update:

• The system table 'sysdiagrams' is now excluded from SQL Server 2005 reports.


• Views with the table owner of 'sys' are now correctly excluded from SQL Server 2005 reports.


• The following system stored procedures are no longer documented: 'sp_alterdiagram', 'sp_creatediagram', 'sp_dropdiagram', 'sp_helpdiagramdefinition', 'sp_helpdiagrams', 'sp_renamediagram', 'sp_upgraddiagrams' and 'fn_diagramobjects'.


• The date and time of errors is now added to the error log file.

Download SQL Documentation Tool Trial Version

SQL Documentation Tool 7.2 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.2 offers the following update:

• Database stored procedures are now listed in the RTF format report, complete with optional colour coding and syntax highlighting of the Transact SQL. Note that some RTF documents may need to be imported into WordPad and saved again before they can be opened with Microsoft Word.


• Table indexes are now listed on the table details page.

Download SQL Documentation Tool Trial Version

SQL Documentation Tool 7.1

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.1 offers the following update:

• In response to user demand, the SQL Documentation Tool now has options to specify what should be documented in a project. It is now possible to document all/some or none of the following: tables, views, stored procedures, triggers, full-text catalogs, indexes, jobs and DTS packages.

SQL Documentation Tool Trial Version

SQL Documentation Tool 7.0

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.0 offers the following updates:

• Changed the way stored procedure field lengths are reported. Lengths are now reported only for fields of type char, nchar, varchar, nvarchar and varbinary. nchar and nvarchar field lengths are reported in terms of the amount of characters that can be stored within them.


• Stored procedure column types (e.g. input, output etc.) are now included in the report.


• GUI buttons now disabled while data being extracted or project being documented.


• It is now possible to specify an HTML report colour scheme.


• Added tooltips to the Project options Window.


• The project options now include the ability to include a user-specified HTML snippet within the HEAD element of the pages produced by the SQL Documentation Tool. This makes it possible to add a custom Cascading Style Sheet (CSS) to format the HTML report's output.
  

SQL Documentation Tool Trial Version

SQL Documentation Tool 6.9.1

The SQL Documentation Tool creates comprehensive technical documentation reports for Microsoft SQL Server databases. Version 6.9.1 offers the following updates:

• Changed the way data field lengths are reported. Lengths are now reported only for fields of type char, nchar, varchar, nvarchar and varbinary.
• nchar and nvarchar field lengths are reported in terms of the amount of characters that can be stored within them.
• Improved error handling when buttons are pressed in GUI without items being selected first.
• Improved error handling in DataStore accessing class.
• More buy now buttons added to sample output in evaluation version.
• Increased size of buy now button in evaluation version.
• Decreased the connection timeout time, making it easier to know if the SQL Server connectivity has not been correctly established.
• Database specific content data extraction routine now reports correct msdb database name.

SQL Documentation Tool 6.8

The SQL Documentation Tool creates comprehensive technical documentation reports for Microsoft SQL Server databases. Version 6.8 offers the following updates:

• There is now an error reporting text box on the GUI. Brief details of errors are now added to this text box. Note that not all errors are serious, for example the SQL Documentation Tool will show full text index errors if the SQL Server does not have full text indexing available or configured, and SQL Server 2005 Express Edition does not support either DTS packages or Job schedules.
• The SQL Documentation Tool will now document databases named using reserved words or other non-recommended naming (e.g. spaces or underscores).
• Full application errors are now added to the log file.
• The error trapping routines have been greatly improved detailed error messages are appended to the project's log file. Note that not all errors are serious, for example the SQL Documentation Tool will show full text index errors if the SQL Server does not have full text indexing available or configured, and SQL Server 2005 Express Edition does not support either DTS packages or Job schedules.
• Fixed a small issue with the logging of SQL Server Job names to the log file.

SQL Documentation Tool 6.6

The SQL Documentation Tool creates comprehensive technical documentation reports for Microsoft SQL Server databases. Version 6.6 offers the following updates:

• Corrected a problem with the display of View columns in the documentation.
• Removed system views "sysconstraints" and "syssegments" from database documentation.
• Corrected an issue with the use of custom connection strings.

SQL Documentation Tool 6.7

The SQL Documentation Tool creates comprehensive technical documentation reports for Microsoft SQL Server databases. Version 6.7 offers the following updates:

• Product now fully integrated with RegNow's affiliate marketing system.
• Added more buy now links to the evaluation version and removed some of the pop-up Window registration reminders.
• Logs folder is now created if it does not already exist.

SQL Documentation Tool 6.5

The SQL Documentation Tool creates comprehensive technical documentation reports for Microsoft SQL Server databases. Version 6.5 offers the following updates:

• Added a Connection String field to the Connection properties window - this will allow a custom connection string to be specified. Note that a custom connection string must be specified for SQL Server 2005 - see the documentation for more information or try http://www.connectionstrings.com/.
• Stopped system views appearing in documentation output.
• The project "use table column descriptions" option is now correctly checked/unchecked.
  Fixed a minor status error in the database documentation routine.