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

Database Documentation Expand / Collapse
Author
Message
Posted Wednesday, April 06, 2005 8:10 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 07, 2013 6:16 AM
Points: 90, Visits: 350

Greetings to the group!

I've been told that our Sarbanes-Oxley requirements include documentation of all of our databases.

My thought is to generate the SQL scripts (through Enterprise Manager) for all objects in each database.

Does this sound appropriate? How are others handling this? Some db management tool?

Thanks,

Bob

Post #172415
Posted Thursday, April 07, 2005 7:21 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, July 12, 2012 11:03 AM
Points: 40, Visits: 139
Check out http://www.apexsql.com and you want to take a look at ApexSQL Doc.  This tools is awesome.  It can be run through a scheduled job and it creates a compiled help file with links between related objects and everything.


Post #172834
Posted Thursday, April 07, 2005 8:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, June 16, 2006 10:27 AM
Points: 316, Visits: 1
I second the nomination;  ApexSQL Doc is a great tool for producing dynamic .chm file documentation. 


Post #172883
Posted Thursday, April 07, 2005 2:39 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, August 28, 2006 4:40 AM
Points: 27, Visits: 1

WoOoOoOoW ! This tool is amazing

Thanks for the link, dude




Ezz Khayyat
Post #173041
Posted Saturday, October 28, 2006 9:55 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, October 18, 2013 4:06 PM
Points: 471, Visits: 589
This is an old thread, but I just had to add that SqlSpec is better than apexsql doc for this purpose. But then I am biased - I wrote SqlSpec

Seriously though, it's worth a look, and it's MUCH cheaper than apexsql doc.

Link is in my sig below.


---------------------------------------
elsasoft.org
Post #318875
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse