Solved

How to document an SQL Server 2005 Database...

Posted on 2006-06-13
4
237 Views
Last Modified: 2008-02-01

Hi guys...
I need to know how to make a good documentation of my DataBases.

Currently I'm starting what will soon be a tables and stored procedures mazze,
and I need to have it well domented to allow future dev's get into it as smoothly as possible.

I need best practices, software links... everything you may have.

Many thanks!

Alex :p
0
Comment
Question by:Alexandre Simões
4 Comments
 
LVL 13

Assisted Solution

by:MikeWalsh
MikeWalsh earned 250 total points
ID: 16899392
Alex:

Well first you need to understand the difference between a logical and physical design. You need to understand what your design should look like and understand database principles there... Look Up "Data Model", "Database Model", "Relational Database Design", "Normalization" etc. etc.

I would reccomend some books for this.. Database Design for mere mortals, SQL Server 2000 Database Design..

Once you understand those concepts, you can begin the design and build.

After you are done designing and building the following information will be key for the handoff:

1.) The actual data models

2.) A "Run Book".. Explain everything that they will ever need to know to rebuild the server. How you configured the OS, how the drives were configured, what SQL version and service pack level was installed, advanced memory options, SQL Server Server settings.. Screen shot all of this information, write about it and put it in a few places..

3.) Explain the database and application. Write a document about the database itself. Go through the physical design in the document talk them through it. Explain the entities and how they tie into the application. Talk about any data access layers. Do an informal talk-through of a use case.. Describe who is who and how they will use the database. Describe the security model and any considerations.

4.) Talk about the jobs on the server. How to restore your backups, talk about your backup/recovery model, etc. etc.

Basically give as much information as possible.
0
 
LVL 23

Assisted Solution

by:Racim BOUDJAKDJI
Racim BOUDJAKDJI earned 50 total points
ID: 16900600
For database design you need to get some serious books about design...The vast majority of books written are publication of authors who have no clue about relational model and therefore correct design: in a word, don't throw away your money on buying books written by ignorants...

Avoid at all costs books such as 'learn design in 21 days' or 'design for dummies' type of cookbook approach...They have no value at all...Database design is a complex issue if you want to it right... Some good reading....

Introduction to Database Systems (CJ Date)
Practical Issues in Database Management
Check out third manifesto...http://www.thirdmanifesto.com

Look for publications from CJ Date, Darwen, Pascal, Mc Goveran...on Amazon or equivalent...

Hope this helps...
0
 
LVL 1

Accepted Solution

by:
MySt1k earned 200 total points
ID: 16905182
Hi Alex, if its tools that you want, there is vision from microsoft or rationale rose from that can be used to create models.

there is also a tool made by apex that is worth looking if you want to autogenerate a CHM.
http://www.apexsql.com/sql_tools_doc.asp
there is also SQL SCRIBE From ag software... http://www.ag-software.com/Content.aspx?Doc_id=1001

i used apex + visio on a couple of projects,
with apex, you can add tags to your ddl scripts that will be inserted in the documentation when it'll be generated.


hope this helps...
0
 
LVL 30

Author Comment

by:Alexandre Simões
ID: 17054717
Thanks guys...
I think it's time to close this one.

Alex
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now