printing - how to print database diagram sql

Question

I would like to print a SQL Server database diagram. I'm using SQL Server Management Studio, I right clicked on the diagram, and selected "View Page Breaks".

I wanted to have the diagram in A3 Format but when I tried to print it had 4 pages. Is there a way to print the whole diagram in just one page?

question from:https://stackoverflow.com/questions/1207073/how-to-print-database-diagram-sql

Answer 1

On SQL Server Management Studio

In the Database Diagram, right click and select 'View Page Breaks'

Then from main window menu select, File > Page Setup

Select Page Size and Orientation - A3 and Landscape are most likely best options.

And Print Scale - this is the % value that should hopefully enable you to fit all tables onto one page.