Q:

Export ER diagrams from SSMS

I have some ER diagrams created in the development server. I want to export this as PDF and share with my analyst for further usage. The diagram needs to be in PDF format alone since the analyst doesn't have SSMS in his system. I followed the below steps:

Generate ER diagram
Right click and select 'Copy diagram to clipboard'
Paste the copy into paint
Save the image as png/jpg and convert to PDF

I am struck in Step 3 since when I paste the ER diagram, I only see the table heading and not the internal column names. Any tools available or any other workaround to make this process easy? any help?!

A:

If you are using Windows 10 you could  use built-in Microsoft Print to PDF.
SSMS -> Diagram -> Right click -> View Page Breaks -> Place tables in correct way -> Print -> Microsoft Print to PDF

