Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Documenting several SQL Server DBs? Expand / Collapse
Author
Message
Posted Tuesday, April 14, 2009 3:16 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 14, 2014 7:54 AM
Points: 319, Visits: 782
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

Post #696381
Posted Wednesday, April 15, 2009 2:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 16, 2009 1:02 PM
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!
Post #697895
Posted Friday, March 12, 2010 7:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 10:00 AM
Points: 34, Visits: 191
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
Post #881777
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse