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.

Create Database Diagram

Add Tables

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.

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.

View Page Breaks

Click File -> Page Setup

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,
My Tech Blog:


No responses found. Be the first to comment...

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: