Post reply

How to copy the ER diagram from SQL server 2008

  • January 21, 2013 at 2:43 am

    #393979

    Hi all,

    I wanted to copy the ER diagram to a word file. I generated the ER diagrams but the tables are listed individually without any connectivity among them.

    How do i access it and take a copy of the ER diagram?

    Please help

  • January 26, 2013 at 8:30 am

    #1581297

    The data for those is stored in a table, but I suspect you want the image which is only rendered inside SSMS. Take a screenshot and pste it into Word. If you want to clean it up bring the screenshot into your favorite image editor and crop away everything except the piece of the diagram you want to show. Then you can bring the image into your Word document.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • January 26, 2013 at 7:38 pm

    #1581344

    arthi.anan (1/21/2013)

    I generated the ER diagrams but the tables are listed individually [font="Arial Black"]without any connectivity among them[/font].

    Do you have any Foreign Keys between the tables? If not, you're out of luck.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

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

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