How can we export Database Diagram into image/picture format?

  • I have created database diargram successfully. Now I want to export created database diagram into jpeg file or any suitable format that should allow user to view correctly.

    Can anyone tell me how to do this?

    Thanks in Advance

    Vinayak.

  • open the database diagram and right click then select copy to clipboard. Once on the clipboard open your favourite image editor Paint.net and paste into a new image

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thanks, it worked.

  • is there a way to automate this ?

  • when i click on Database diagram to copy to clipboard and copy into paint ,if i want to save image am getting "There is not enough memory or resources to complete operation Close some program's and then try again" error

  • The Database Diagrams support in SSMS is pathetic. VISIO is uber pathetic. I NEVER want to edit a schema in the diagram and I ALWAYS want to print to PDF automatically. Another serious drawback is it doesn't allow displaying a table copy in another part of a diagram to avoid crossover lines. I also can't iterate through the binary format to figure out which table is in which diagram.

    There a a few things you can do:

    1. Hire a college intern to print them for you.

    2. Use ERwin...a great product if they didn't force you to first implement a logical data model which is a complete waste of time.

    3. Install a PDF printer driver (still a lot of manual effort to print 40 diagrams).

    4. Copy your database, delete all data rows, shrinkdbfiles, and give the whole database with diagrams to your customers.

    5. Write a custom solution that perhaps creates webpage diagrams that are easily deployed to customers.

Viewing 6 posts - 1 through 5 (of 5 total)

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