SQL Server Performance

Database Documentation

Discussion in 'SQL Server 2005 General Developer Questions' started by reethu, Aug 9, 2006.

  1. reethu New Member

    Hi guys, my manager asked me that to do documentation; right now we are using MSSQL SERVER 2005 Databases, here you assume I am new to make documents on any database but good idea about databases currently that data warehouse in development environment need to done this documentation before go on test environment . So that way you advise me to prepare a document.
    Here is my main concerned how to start and what things should we keep in mind while preparing document (what are measurements).if you any prepared documents could help to start or there tool we should use (power point) them. any help appreciated


    SRJ2005
  2. FrankKalis Moderator

    First thing I would probably do, is to script the whole database. That way you already have some stuff to build the rest upon. If you have some money to spare you might want to have a look at the software section here. There are specialized third-party tools for documenting purposes available.

    --
    Frank Kalis
    Moderator
    Microsoft SQL Server MVP
    Webmaster:http://www.insidesql.de
  3. FrankKalis Moderator

    Btw, moved this to the 2005er forum. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
  4. dineshasanka Moderator

    There are few tools like DBDocumentor and SQL Doc. check the spolight section

    ----------------------------------------

Share This Page