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?
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. The additional note about the Print Scale makes this a very useful answer.
Right click on the database containing the diagrams. Click on All Tasks then on "Export data". The Import / Export option will be displayed, click Next. Define the source and then click Next.
Save and print an ER diagram - DBeaver TutorialOn the bottom toolbar, you'll find a button to print it out. This opens up your operating systems printer dialogue, where you can choose an output device and paper size and other configurations. You can then print it out to a piece of paper.
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.
Set the page zoom level on the print properties page (in addition to setting the page size to A3).
Switching back to the diagram with 'View Page Breaks' selected will show you when you have all the tables positioned properly onto one page.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With