Creating Database Diagram in SSMS and Printing in PDF using CutePDF
In this article, I will walk you through series of steps to create a database diagram in SQL Server Management Studio, adjusting page setup options to fit the entire diagram in one single page and finally printing it to a PDF file using CutePDF software. In this way you will make sure you print your entire database diagram in one single page irrespective of its complexity.
This is an easy 3 step process.
Step 1: Create Database Diagram first
Create database diagram for your database by selecting all of the tables listed or selected tables.
Right click Database Diagram node under db and click new database diagram.
Step 2: Install CutePDF before adjusting Page to fit diagram in one single page
Save Database diagram and Install Cutepdf with the help of link below.
http://www.cutepdf.com/Products/CutePDF/writer.asp
Step 3: Adjust Page setup to fit diagram in one single page and finally Print using CutePDF
Right click on the database diagram and click View page breaks.
Click File -> Page Setup
In Page Setup, Printer name should be selected as CutePDF (Installed during Step2)
Adjust Paper Size and Print Scale accordingly to fit entire diagram in one single page. Below is just an example for my db diagram to fit in single page as shown below.
Zoom out to shrink your database diagram to see if entire diagram fits in single page like below. (Imagine below two images can be joined - couldn't demonstrate as single image due to diagram complexity)
Note: you can see it is fitted in one page (display at bottom as 1-1)
Click File -> Print
Select CutePDF as Printer. Print and save the PDF file.
If your database diagram does not fit correctly, Make sure to Drag and adjust your diagram accordingly and change page setup settings to fit correctly
Hope this helps!
Thank you,
Sheik
Mohmd.Sheik@gmail.com
My Tech Blog: Sheikatdns.blogspot.com