SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Documenting several SQL Server DBs?


Documenting several SQL Server DBs?

Author
Message
aaa121
aaa121
Mr or Mrs. 500
Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)Mr or Mrs. 500 (501 reputation)

Group: General Forum Members
Points: 501 Visits: 783
Not sure if this is in the right forum, but I thought maybe this is the best match.

I am soon going to be starting a task to look at and investigate how several systems work. These systems all use SQL Server 2000/5/8 as a back end database.

I need to understand what these systems do, but most importantly I need to document this in a way other SQL professionals can understand.

Does anyone know of the best practices to do this or does anyone out there have any example templates I could look at to gain some inspiration?

Thanks for your help
nclark-959684
nclark-959684
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 18
I actually found your post while searching the archives for the same material. What I came up with is the following information that I'll be using to document the many databases I have to take responsibility over. Believe me, I'm no happy camper for having to do this kind of stuff and would rather pistol-whip those before me, but hey, what a learning experience it will be!

Tools:
http://xsqlsoftware.com
http://www.winnershtriangle.com
http://www.bidocumenter.com
MS Best Practices Analyzer for 2000, 2005, 2008
MS Visio using reverse engineering process

SQLServerCentral Topic/Article Titles:
- Documenting SQL Server 2000
- Document Your Database
- Documenting Stored Procedures
- Documenting Several SQL Server DBs
- How to Document SQL Server

All the above gave me a good start and the tools I found here and other places do soooo much of the work for me that I know I'll be up and running with documentation in no time. Hope I've helped!
kmonroe
kmonroe
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 218
Not sure if this is still an issue for you but Red Gate's SQL Doc tool is awesome. You choose the level of what you want to document and then choose an output format and it rips through it really fast. The nice thing is that it can dump out html files that can be very easily navigated.

Kevin
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search