SQL databse : generate documentation

kishore67kishore67 Posts: 2
edited February 2, 2011 12:21PM in SQL Doc Previous Versions
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
· Share on Twitter

Comments

  • James BJames B Posts: 1,124 Silver 4
    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.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.