How to create a PDF database diagram in SQL Server?

For better quality After generating the diagram in sql server management studio

Go to File -> page setup

Set print Scale into 10 or lower. Select paper size into tabloid Set Orientation into Landscape Set printer name microsoft print to pdf After that press ok enter image description here

And go back to generated diagram Right click and select view page break

enter image description here

Now you can drag and drop each tables inside the page you want.

After that click on File ->print Select Microsoft print to PDF and hit print button.

You will get a PDF of ER diagram


Using SQL Server Management Studio 2014:

  1. Right click diagram area
  2. On the menu bar select "Database Diagram" >> "Copy diagram to Clipboard"
  3. Open MS Word and paste it

To display your diagram in PDF format, follow the below steps:

  • Click anywhere in the diagram area
  • Right click -> Copy to clipboard
  • Paste it in paint window
  • Save it as a png image
  • Open browser and search for png to pdf converter online tool
  • Convert it to pdf

I have not used it myself but SchemaSpy appears to be able to draw an ERD using Graphviz, which can be output into ps2 (among many other formats) and converted to PDF.

Tags:

Sql Server

Pdf

Er Diagrams

Recent Posts