Post reply

ER diagram

  • February 17, 2005 at 8:03 am

    #60699

    Is there any tool to generate ER diagram in sql server 2000. If not where can i generate an ER Diagram.

     

    Thanks.

  • February 17, 2005 at 8:23 am

    #542822

    Yours is not an unique question. See this link:

     

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=140736

    ------------------------------
    The Users are always right - when I'm not wrong!

  • February 17, 2005 at 11:23 am

    #542900

    You can use some of the next tools:

    Power Designer, Erwin, or Visio

     

    Regards

  • February 18, 2005 at 8:14 am

    #543086

    If you just want an E/R diagram of your database in Enterprise Manager, expand the database you want to generate the diagram for. There is a Diagrams entry. You can right click on that and select Generate New Diagram.

    Be careful, because if you change the diagram (add a relationship, delete a table, etc.), and then save the diagram, you are actually changing the schema of your database (not just the diagram). This is one good reason to use an E/R tool like E/R Studio, ERWin, Visio, etc. They will generate a diagram seperate from the database and allow you to save changes without modifying the schema of your database itself.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply