SQL Database Documentation

Question

5.00/5 (1 vote)

See more:

Hi,

I am using sql database which contains 100 tables and around 50 sp .I get responsibility for create documentation of this database ,but i haven't any idea how to create it.Please help me about how i can create database documentation.

Thank You

Posted 10-Apr-13 21:47pm

ddarshan

Updated 11-Apr-13 2:00am

Shanalal Kasim

v2

Add a Solution

Comments

ddarshan 11-Apr-13 4:24am

Can we create documentaion manually? And if we can do it,Please give me sample of it.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Shanalal Kasim · Answer 1 · 2013-04-10T22:52:00

Solution 2

Hi,

Download sample template from here[^]

Sample 2[^]

Sample 3[^]

Posted 10-Apr-13 22:52pm

Shanalal Kasim

Updated 10-Apr-13 22:55pm

v4

Comments

RedDk 12-Apr-13 13:44pm

archaeologydataservice.ac.uk ... very cool stuff!

Thanks SK!

Shanalal Kasim 12-Apr-13 20:44pm

Thanks

OriginalGriff · Answer 2 · 2013-04-10T21:51:00

Solution 1

Big job!
There a bunch of tools which can make it easier. There is a list of some of them here: http://www.mssqltips.com/sqlservertip/1250/sql-server-documentation-tools/[^] - it might be worth having a look at them first before diving in to a manual task.

Posted 10-Apr-13 21:51pm

OriginalGriff

Comments

ddarshan 11-Apr-13 4:25am

Can we create documentaion manually? And if we can do it,Please give me sample of it.

RobCollins · Answer 3 · 2013-04-11T21:47:00

Just use any third party documentation tool such as ApexSQL Doc or SQL Doc or any other from the list @OriginalGriff posted.

Even if you don't have budget for third party tools you can use them in trial mode to get the job done.

If you have 150+ database objects to document you'll spend a ton of time and you still won't do it as good as these tools do it ;).

SQL Database Documentation

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us