Red Gate forums :: View topic - SQL databse : generate documentation
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 2
SQL Doc 2 forum

SQL databse : generate documentation

Search in SQL Doc 2 forum
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
kishore67



Joined: 01 Feb 2011
Posts: 1

PostPosted: Tue Feb 01, 2011 4:35 pm    Post subject: SQL databse : generate documentation Reply with quote

Hi,

I have already generated a documentation for a sql server 2005 database using sql doc. I have added description to tables(250+) and variables.

Now we have added couple of tables and variables to same database and want to generate the word documentation.

do I need to add the description for all tables once again or is there any other way to acheive this?

Thanks for your help.

K
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Wed Feb 02, 2011 6:21 pm    Post subject: Reply with quote

The documentation you already entered should still be there. When you enter descriptions against objects using SQL Doc, the information is stored in the database as extended properties using MS_Description - so you only need to add information for the new objects.

The only time this won't happen is if you have restored the database using a backup that was taken prior to it being documented the first time round, as this will remove everything you entered.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group