hi all

Are there any free (opensource) documentation tool for sql server 2005 support,
i want to get details description of my all tables (with extended properties )

Thanks
IndikaD

Here is a script I wrote that will return the information in an html format.

http://www.mssqltips.com/tip.asp?tip=1499

hi ken
thanks lot for you script

http://www.amitchaudhary.com/SQLDocSharp_WordToHTML.htm

Have you tried BIDocumenter Database Edition from Pragmaticworks... its free sql server database documentation tool

Are there any free (opensource) documentation tool for sql server 2005 support,
i want to get details description of my all tables (with extended properties ) 

Hi,

This one is OKay: http://sqldbdoc.codeplex.com/ command line utility, produces a single html file.

Or you can try my new tool LiveDoco web app (IIS, ASP.NET MVC3+JQuery): http://www.livedoco.com/

It's not free though :)

Yes, free options are also available, consider using...
http://sqldoc.codeplex.com/
http://turtle.codeplex.com/

@amitchaudhary

Link dead

• Edited by SilentKnights Wednesday, May 22, 2013 3:00 PM

@amitchaudhary

Link dead

• Edited by SilentKnights Wednesday, May 22, 2013 3:00 PM

@Nayan ...Not free now

• Edited by SilentKnights Wednesday, May 22, 2013 2:59 PM

@Nayan ...Not free now

• Edited by SilentKnights Wednesday, May 22, 2013 2:59 PM

I know this is an old thread but the free (workgroup edition) of our product XIA Configuration allows you to document all the databases and tables on a single SQL server instance including stored procedures, tables, functions and extended properties.

http://www.centrel-solutions.com/XIAConfiguration/capabilities.aspx?capability=SQLInstance

Follow this link to get the free license.
http://www.centrel-solutions.com/XIAConfiguration/workgroupedition.aspx

Hope this helps.

Thanks,

Dave
SQL Server Documentation Tool

Hi IndikaD,

Recently we released powerful free tool that does that - Dataedo.

It supports SQL Server 2005+, Oracle 9i+ and other databases in near future. You can export to PDF and soon to Doc, HTML and Excel too.

Have a look at:
www.dataedo.com

Greetings,

Piotr Kononow
Dataedo product manager

• Proposed as answer by PiotrKw Wednesday, March 18, 2015 2:17 PM
• Unproposed as answer by PiotrKw Wednesday, March 18, 2015 2:18 PM
• Proposed as answer by PiotrKw Wednesday, March 18, 2015 2:18 PM

Document your SQL Server database with free tools

http://erikej.blogspot.com/2013/12/document-your-sql-server-database-with.html

You can to id with Dataedo. It has free edition (it's not open source). It reads schema (tables and views with columns, procedures and functions with parameters). It reads MS_Description and you can document directly in it's repository. It exports to PDF, HTML and Excel (the last two in Pro only).