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?!
Advertisement
Answer
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