Free Tool for SQL Documentation

Category: sql server documentation

Question

DORMANTROOT on Fri, 22 Feb 2008 20:04:24


 

Folks,

 

Does anybody know of any free tool that I can use to create documentation for all the stored procedures and table in SQL 2005?

 

Thanks,

John

Replies

Jonathan Kehayias on Sat, 23 Feb 2008 03:28:07


What kind of documentation are you after?  I have a script that creates a webpage html file for an entire database using tables.  I use it to provide a data dictionary to new developers.

 

Jonathan Kehayias on Sat, 23 Feb 2008 03:33:52


A google search brings back the following:

 

http://www.codeproject.com/KB/database/sqldoc.aspx

 

http://www.codeproject.com/KB/database/SQL_DB_DOCUMENTATION.aspx

 

http://weblogs.asp.net/jgalloway/archive/2006/09/28/_5B00_Tool_5D00_-Data-Dictionary-Creator-_2D00_-Rapidly-database-documentation.aspx

 

These are roughly similar to what I have.  I needed a specific format, so I wrote my own, but recall doing searching for this a few years back, and there are a number of good tools out there for free.

 

dotnetvj on Sun, 24 Feb 2008 03:02:09


Hi,

Generating Tables information is very easy, its just that you need to know the system tables which stores the columns & their properties like Not Null or DataType etc. If you want some kind of idea around what kind of documentation that you need for your database then check out the below link. tho this link related to one toll but you can get some idea about this.

http://www.winnershtriangle.com/w/Products.SQLDocumentationTool.asp

Thanks -- Vj

http://dotnetvj.blogspot.com

DORMANTROOT on Tue, 26 Feb 2008 14:24:00


Jonathan,

 

Thanks for the reply. Basically I'm looking for something like 'Red Gate SQL Doc 1' program. I'll check out the links that you posted.

 

Thanks for your help.

 

John

 

AmitChaudhary on Fri, 17 Apr 2009 14:22:26


SQLDoc Sharp could be the answer.
SQLDoc Sharp, an interactive tool designed to generate the SQL Server 2005/2008 documentation.
This is free solution, Enjoy...!
http://www.amitchaudhary.com/ .
Microsoft technologies (.NET+SQL SEVER+BIZTALK+MIIS)

AmitChaudhary on Fri, 07 Aug 2009 05:30:42


If you want to export the generated documentation to Excel, Pdf or XML then look at, turtle.codeplex.com

A. Sajid on Mon, 12 Nov 2012 07:30:41


Good work.

Really helpful ! Thanks

hasla17 on Fri, 08 Nov 2013 11:32:09


love it too

BALTLOKIS on Wed, 10 Feb 2016 15:02:57


Fully agreed! it helped me a lot

http://www.baltlokis.lt