Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003

    Unanswered: Where should I create ERD?

    Hello, everyone:

    Does anyone offer the idea where I should create ERD in SQL Server? And how?

    Thanks a lot.


  2. #2
    Join Date
    Nov 2004
    on the wrong server
    Provided Answers: 6
    well you can use diagrams but changes to those actually change the database. you do not have to keep the ERD in SQL Server. you can use stuff like Erwin and Visio to create disconnected documents and you can store them with the rest of your documentation. You can even use MS Word to draw your happy boxes and lines.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    I like PowerPoint for thumbnail diagrams of table relationships. Use the "Connector" objects between boxes.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

  4. #4
    Join Date
    Mar 2004
    Do you really use PowerPoint as a CASE tool? :O So ER, logical and physical design diagrams are a bunch of rectangles and lines, right?
    If you are going to do your homework by some paintings yep, PowerPoint is ok but for production use (physical design generation, Data access layer code generation and...) I recommand Sybase PowerDesigner. For ER purpose only there is a complex tool called ER Studio by Embarcadero inc.

  5. #5
    Join Date
    Jan 2003
    Provided Answers: 17
    Create the first one on paper. As the data model evolves, then you can move on to Visio, Embarcaderro, or whatever you like.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts