SQL Server: How to export Database Diagram to Excel

In SQL Server Management Studio, how do you export database diagrams into another application like Microsoft Excel?

Creating database diagrams in SQL Server Management Studio can be a useful exercise.  It allows you to visually see the structure of your database tables and the relationships that have been created between the database tables.

While it is useful to see these database diagrams, people often ask How can I export my database diagram from SQL Server Management Studio to another program like Microsoft Excel?

Exporting to Excel or Word can be very useful if you want to share your database diagrams with other people.

But how do you do it?  You can’t use Copy and Paste, because you can’t copy the diagrams.

The simple answer is to look up at the menu bar in SQL Server Management Studio.

When you are viewing your database diagram, a new menu appears called Database Diagrams.

From the Database Diagrams menu, select the Copy Diagram to Clipboard menu option.

Once you have the database diagram copied to the clipboard, you can paste it as normal into any other application you want, like Excel, Word or even PowerPoint.  By pasting it into another document you can save the database diagram as a separate file and share it with colleagues.

Comments are closed