Results 1 to 7 of 7

Thread: ER Question

  1. #1
    Join Date
    Jun 2004
    Posts
    57

    Unanswered: ER Question

    I need to output a printable ER diagram from a SQL Server db i inherited (about 125 tables). I can use the diagram node to add the tables. Is there a lazy-person's way to copy this into an easily printable doc?

    Ray

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    yeah...get a copy of ERWin.....and fork over 5,000

    If you have visio 2000 pro, i think you can do the same thing much more cheaply
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You can print the Diagram directly from Enterprise Manager's Diagram window. Use the Printer Icon in the menu bar (for some reason Print does not appear in the Menu system...).

    Unfortunately, ER does not give you many options for printing. Slightly better is to create an MS Access Data Project linked to your SQL Server database. Your diagrams will appear in the project, and the Access interface gives you more control over printing.

    You asked for "Poor man's"....
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    If you have VS 2003 you can have a better control over datadiagrams. I use for exclussively for documentation and it pays off being meticulous (memory lapses, who isn't suffering from this syndrome?)
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by rdjabarov
    who isn't suffering from this syndrome?
    what syndrome?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by r937
    what syndrome?

    I've heard that the memory is the second thing to go.

    -PatP

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's the first....ummm...never mind....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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