August 7, 2009 at 3:22 am
Comments posted to this topic are about the item Database Documentation Using Red Gate's SQLDoc
August 10, 2009 at 7:38 am
I'm interested in this type of Documentation. I can see where this data will be very valuable but I'm a little scared at what appears to be a very complex process in entering the data.
August 10, 2009 at 8:58 am
It isn't as complex as it looks. The complexity is in having to rename directories as a result of the timestamp facility but Red-Gate have that down as a thing to be fixed.
The main thing is to start attaching MS_Description properties to your objects. I am probably committing an unmentionable sin by mentioning that there are other database documentation tools out there and they all use the MS_Description property.
Once the MS_Description properties are set they are there for all time and are backed up with the database so you don't have to worry about losing them.
August 11, 2009 at 6:11 am
Interesting.
If I load the software on my PC can I direct where the new diectories should be created? I thinking of putting the output on a shared network disk as word documents.?
The package also allows you to edit the descriptions or comments which is the data stored as MS_Description. If I make a change or add new information does the edit feature update the database or do these changes only get reflected in the word document report the one time. If I rerun the report a second time are the changes gone?
I'm trying to determine which would be the better method of updating the MS_Description information.
August 17, 2009 at 9:14 am
The idea of automatically documenting a database is a fantastic idea, especially when you store information in the extended properties. Unfortunately SQL Doc is not very flexible and the last time I checked with Red Gate, they had no documented plans for enhancing this tool.
-David
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply