Click here to Skip to main content
11,713,069 members (89,438 online)
Click here to Skip to main content

Microsoft SQL Server Database Documentor

, 17 Aug 2006 CPOL 44.4K 608 49
Rate this:
Please Sign up or sign in to vote.
A Microsoft SQL Server database documentor, using Crystal Reports.

Sample Image - dt2.jpg

Introduction

This project uses Crystal Reports to generate a database schema listing on a Microsoft SQL Server database. The listing includes extended column information including column descriptions. This project requires Visual Studio 2003 or 2005, .NET Framework 1.1, and the Crystal Reports for Visual Studio component.

The generated report lists column names, data types, size, description, etc. Primary key columns are preceded by an asterisk. Columns names are italicized when the column is allowed to be NULL in the table.

Background

One day I set out to document a database that I had been studying. Using the Table Designer in Enterprise Manager, I began entering descriptions of the columns of each table. Later on, I discovered that there is no way to print out the column descriptions using EM. I did a little research and discovered how to get the descriptions out of the sysobjects table.

Using the Code

The project can be built and run with just a little setup. To install the project, unzip it to a directory of your choosing, for instance c:\projects\dbadoc. Create a virtual directory in IIS and set the path to c:\projects\dbadoc\client.

Open Visual Studio and build the project. If you are using VS 2005, the project should convert with no problems. That's it!

Points of Interest

  • Don't ask me why I used VB for the code-behind and C# for the data classes. No, really, don't ask.
  • I don't know the configuration steps or failure characteristics when Crystal Reports is not installed and configured with Visual Studio. If you go through this setup, kindly email me and I'll update with those directions.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

gogglin
United States United States
No Biography provided

You may also be interested in...

Comments and Discussions

 
GeneralError Loading in VS2005 Pin
MarcEleazar30-Apr-08 15:43
memberMarcEleazar30-Apr-08 15:43 
GeneralErrors while loading on VS 2005 Pin
MarcEleazar21-Apr-08 20:29
memberMarcEleazar21-Apr-08 20:29 
GeneraldbaDoc - Error in loading the Solution Pin
MarcEleazar5-Mar-08 17:41
memberMarcEleazar5-Mar-08 17:41 
GeneralRe: dbaDoc - Error in loading the Solution Pin
gogglin7-Mar-08 20:25
membergogglin7-Mar-08 20:25 
QuestionGreat Concept, But Nothing Shows? Pin
Member 199949326-Feb-08 5:11
memberMember 199949326-Feb-08 5:11 
GeneralRe: Great Concept, But Nothing Shows? Pin
gogglin7-Mar-08 20:22
membergogglin7-Mar-08 20:22 
GeneralRunning into errors on compile Pin
e4thenf423-Jun-07 11:28
membere4thenf423-Jun-07 11:28 
GeneralRe: Running into errors on compile Pin
gogglin28-Jun-07 4:10
membergogglin28-Jun-07 4:10 
GeneralReporting Services Pin
RogerMCT23-Aug-06 5:13
memberRogerMCT23-Aug-06 5:13 
AnswerRe: Reporting Services Pin
gogglin23-Aug-06 11:51
membergogglin23-Aug-06 11:51 
GeneralNeat! Pin
amarie22-Aug-06 4:53
memberamarie22-Aug-06 4:53 
GeneralRe: Neat! Pin
gogglin23-Aug-06 11:42
membergogglin23-Aug-06 11:42 

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 | Terms of Use | Mobile
Web04 | 2.8.150819.1 | Last Updated 17 Aug 2006
Article Copyright 2006 by gogglin
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid