enterprise manager (or other software) to document tables and columns for Server2k?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • metaperl
    #1

    enterprise manager (or other software) to document tables and columns for Server2k?

    Hi,

    We have enterprise manager for sql server 2000. I would like to store
    comments about my database schema somewhere in the database. I want to
    store information about the intent of tables and columns.

    We have EM but I am open to any suggestions regarding products.

    Tags: None
    • Erland Sommarskog
      #2
      Re: enterprise manager (or other software) to document tables and columns for Server2k?

      metaperl (metaperl@gmail .com) writes:[color=blue]
      > We have enterprise manager for sql server 2000. I would like to store
      > comments about my database schema somewhere in the database. I want to
      > store information about the intent of tables and columns.
      >
      > We have EM but I am open to any suggestions regarding products.[/color]

      You can use extended properites to this end, and that will inded put
      data about the database into the database itself.

      For more heavy-duty tools for data modelling, the three biggest tools
      on that market are, I believe, PowerDesigner (from Sybase), ERWin
      (from Computer Associates) and Embrocadero. These tools comes with a
      price tag, though.


      --
      Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        Previous template Next
        Working...