ER Diagram to File for SSMS

Abby 41 Reputation points
2022-08-17T16:22:18.847+00:00

If I not mistaken, there was a way to save ER Diagrams generated on SSMS to a file; so, I can share the ERD with the team and have them open it on SSMS.
I can't seem to find it anywhere on SSMS now. Team and I are using SSMS 18.2.1. Did Microsoft disable that feature or am I mistaken?
If not, can anyone point me to how?

Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,678 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 100.9K Reputation points MVP
    2022-08-17T21:37:11.47+00:00

    You can right-click and save to clipboard.

    Or you can press Ctrl-P to print them. (And select "Print to PDF" from the general printer dialogue.)

    0 comments No comments

  2. NikoXu-msft 1,911 Reputation points
    2022-08-18T07:58:31.147+00:00

    Hi @Abby

    SSMS 18 no longer supports diagrams.
    232275-1.png
    However, this feature was reinstated in version 18.1
    232311-2.png
    And some long-standing issues were fixed in version 18.6
    232312-3.png
    For your question I suggest you can use a newer version of SSMS, such as 18.6 onwards.
    For more information on each version of SSMS please refer to:
    https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15#182

    Or you can use some external tools such as Dataedo

    Best regards
    Niko

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments