Solved

How to document an SQL Server 2005 Database...

Posted on 2006-06-13
4
239 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle DB monitor SW 21 48
SQL Server 2012 r2 - Make Temp Table Query Faster 5 42
SQL View nearest date 5 36
Help in Bulk Insert 9 33
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…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

770 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