Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mwilliams@sonicdrivein.co
Starting Member
1 Post |
 Posted - 2005-04-25 : 18:16:32
|
| Does anyone have experience with documentation tools which will analyze your SQL databases and auto generate documentation? We have several SQL servers running and are pushing very high volumn sales data into various servers/datamarts using a couple of hundred SQL jobs, SP's and DTS packages. We would like to be document the databases, including showing the relationships between source and target tables so that we can track our data thru the system. Some documentation tools seem to be able to show dependencies between tables based on analysis of the table references in SP's, but I haven't seen any that attempted to include DTS packages in that process. Any ideas? |
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2005-04-25 : 19:05:52
|
| Try Scribe from A & G Software |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-26 : 08:55:03
|
| This link has a free word program in it that documents your db for you. If you don't feel like paying for it you can download this for free and make some modifications. I've modified this for our site and have it creating my document as .htm pages then saving it out to our web server so our documentation site is updated automatically. One of these days I'll get around to redoing this as a c# project that sits out on the database and is scheduled to run monthly.http://www.outreal.com/databasedocumentor/databasedocumentor.zipMike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Document this mess....