Click here to Skip to main content
Click here to Skip to main content
Go to top

SQLDoc Sharp

, 23 Apr 2009
Rate this:
Please Sign up or sign in to vote.
SQLDoc Sharp, an interactive tool designed to generate the SQL Server 2005/2008 documentation.

Introduction

SQLDoc Sharp is an interactive tool designed to generate the SQL Server 2005/2008 documentation.

It allows you to export documentation to CHM format (Microsoft Compiled HTML Help).
It is also easy and interactive, which allows multiple database documentation.
For more details, please refer to http://www.amitchaudhary.com/.

Background

Finding the answer to, "Is there any free tool for generating documentation from SQL 2005/2008".

Using the Code

After running the application, the initial UI looks like below:

SQLDocSharp.png

Three steps required to generate the documentation.

Step # 1

In the top section, provide the details about the SQL Server. It includes:

  1. Source: Instance Name of the SQL Server 2005/2008 
  2. If want to connect with SQL authentication then:
    1. User Name: Name of the user whose credentials you want to use
    2. Password: Password of the user whose credentials you want to use
  3. In case, to connect with Windows authentication then, only check the checkbox   (Integrated Security) and your current Windows credentials would be used to connect with the specified SQL Server Instance.

Step # 2

Choose the database name from the Database dropdown list, whose documentation you want to generate and then click on the Fetch button.

Meanwhile you can choose/change the File Name of the CHM file which would be generated. And also if required, you then choose to export the metadata/documentation in the XML format too.

Step # 3

Click on the Generate button. And locate the CHM file at the path specified.

After making the selection the SQLDoc Sharp, the UI should look like:

SQLDocSharp Step 2.png

Screen Shots of the Documentation Generated

Index

Index.png

Instance Information

Instance Information.png

Date Source Information

DataSource Information.png

Data Types

List of DataTypes.png

Users

List of Users.png

Tables

tables.png

Table Details

table details.png

Views

Views.png

Procedures

procedures.png

Functions

Functions.png

Triggers

Triggers.png

User Defined Data Types

UDDTs.png 

Points of Interest

At the time of writing the application, I got the opportunity to explore the SQL Server Metadata functions, stored procedures, etc. I also explored ADO.NET GetSchema, MetaCollections, etc. 

License

This article, along with any associated source code and files, is licensed under The Common Public License Version 1.0 (CPL)

Share

About the Author

Amit Chaudhary
Architect
India India
An engineer with approx. 8 years of excellent experience in middle tier applications, analysis, design, development, testing, and maintenance of various client server/web based applications. Has the ability to handle multiple task(s), work independently as well as in team. Motivated, energetic with demonstrated proficiency for learning new technologies and business environments to provide effective and efficient IT solution(s) that envisage a futuristic approach with distributed and object oriented technologies.

Comments and Discussions

 
QuestionNice project! Question about sorting PinmemberYves Rausch20-Jun-12 5:24 
AnswerRe: Nice project! Question about sorting PinmemberYves Rausch20-Jun-12 21:27 
QuestionPre compiled version PinmemberMember 885235719-Apr-12 7:12 
QuestionWon't compile under VS2010 Pinmembersoulfiremage13-Mar-12 1:17 
AnswerRe: Won't compile under VS2010 Pinmemberbwtraz20-Mar-12 8:19 
GeneralIt works Pinmember99sayegh6-Mar-11 17:08 
GeneralCheck/Uncheck/Toggle buttons and Check boxes PinmemberScotDance12-Jan-10 4:02 
Hi
Great little application, but can you tell me if I uncheck either some of the check boxes in each of the tabs or use the radio buttons to the right side of each list should it omit the unchecked items from the final help file that is created? If so I can't seem to get it to do this.
 
Also can it read encrypted stored procedures or functions?
 
Cheers
GeneralTested against Northwind (small db) Just hangs the machine, also have to set chm path to same as exe [modified] Pinmemberjohn blox29-Sep-09 3:01 
GeneralRe: Tested against Northwind (small db) Just hangs the machine, also have to set chm path to same as exe PinmemberHanant11-Oct-09 8:18 
GeneralExcel, Pdf or XML PinmemberAmit Chaudhary6-Aug-09 19:34 
GeneralAgain it hangs Pinmembersore_ron15-May-09 3:51 
AnswerRe: Again it hangs PinmemberAmit Chaudhary17-May-09 20:01 
QuestionUnable to read CHM page with non-English object name Pinmemberdoggy_epaper.tw10-May-09 8:19 
GeneralMy vote of 1 Pinmemberpita200922-Apr-09 7:14 
AnswerRe: My vote of 1 PinmemberAmit Chaudhary25-Apr-09 7:40 
GeneralSQL Doc sharp Pinmemberwkww200422-Apr-09 4:08 
AnswerRe: SQL Doc sharp PinmemberAmit Chaudhary25-Apr-09 7:41 
Questionit didn't work Pinmembermahmola22-Apr-09 3:42 
AnswerRe: it didn't work Pinmembersmesser22-Apr-09 9:39 
AnswerRe: it didn't work PinmemberAmit Chaudhary25-Apr-09 7:41 
GeneralRe: it didn't work Pinmembersmesser25-Apr-09 12:00 
Questiongood but ... PinmemberMember 461770122-Apr-09 3:16 
AnswerRe: good but ... PinmemberAmit Chaudhary25-Apr-09 7:42 
GeneralGood, but ... PinmemberPeni22-Apr-09 2:26 
AnswerRe: Good, but ... PinmemberAmit Chaudhary22-Apr-09 2:27 
GeneralRe: Good, but ... PinmemberHenry Minute22-Apr-09 3:17 
AnswerRe: Good, but ... PinmemberAmit Chaudhary25-Apr-09 7:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web02 | 2.8.140926.1 | Last Updated 24 Apr 2009
Article Copyright 2009 by Amit Chaudhary
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid