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

Comments

  • 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

Sign In or Register to comment.