Database Diagram of more then 100 tables.

Question

Dear Friends,

I am trying to make a database diagram of a database which is having more then 100 table (kinda 110 tables). I am also trying to take one printout of that database. Well, it is showing me 25 pages of A3 size of papers.

  is there any smart way to have all these tables (they are with realtions) on one page ??

Thanks in Advance

Parixit

Answer 1

Hi Parixit,

Regarding to your description, please try to set the page zoom level on the print properties page (in addition to setting the page size to A3).  And switching back to the diagram with 'View Page Breaks' selected will show you when you have all the tables positioned properly onto one page.

Pleas follow the steps as below:
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.>> Print Scale - this is the % value that should hopefully enable you to fit all tables onto one page.

Hope this is helpful.

 

---

Regards, Amber zhang

Answer 2

Hellow amber zhang,
Thanks for prompt response.
I have followed the steps provided by you. Its working well and letting me print in one Page .. Cheers !!
 Now (the BossMan needs it in PDF)   Is there any possibility that we extract the DB Diagram in PDF format.

Thanks in Advance!!

Parixitsinh