Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Diagram printing problems


Database Diagram printing problems

Author
Message
Kurt W. Zimmerman
Kurt W. Zimmerman
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1062 Visits: 1396
Greetings all;
I have seen this issue/problem for a number of releases now and I have not been able to resolve it. I will admit I may be missing something here.

When I design a database I typically create subject area database diagrams. Something I've done for quite some time and is essential when designing complex data structures.

The problem that I have is printing the diagrams. I will spend a fair amount of time to insure I have my tables lined up and not overlapping the page. However when I go to print my entire ER diagram will shift causing tables to overlap pages. This is so annoying!

1) Has anyone else experience this?
2) Does anyone have a resolution for this?
3) Is there something that I'm doing wrong? or is this a known issue?

Thanks in advance.
Kurt

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
Michael Valentine Jones
Michael Valentine Jones
Hall of Fame
Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)Hall of Fame (3.3K reputation)

Group: General Forum Members
Points: 3254 Visits: 11771
Did you set the database diagram to preview the page breaks so that you could see if they overlay page breaks? (Right-click on the back ground and click view page breaks)


You would probably be better off with a third-pary tool for the diagrams if this is very important to you.
Kurt W. Zimmerman
Kurt W. Zimmerman
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1062 Visits: 1396
Yes, in fact I tried everything. What I noticed is when I simply go to print the page breaks shift (or maybe the entities move to the to the center of the diagram.

Unfortunately budgets are tight to purchase a 3rd party tool like ERWin. Any open source solutions you can suggest?

Kurt

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
@SQLFRNDZ
@SQLFRNDZ
Mr or Mrs. 500
Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)Mr or Mrs. 500 (523 reputation)

Group: General Forum Members
Points: 523 Visits: 1173
I guess quest software have some toddler beta free tool?

Check it out


--SQLFRNDZ

Evil Kraig F
Evil Kraig F
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5695 Visits: 7660
Set zoom to visible level (75%-100%).
Database Diagram menu, copy diagram to clipboard.
MSPaint - Paste - Print.

Perfect? No. But it works.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Kurt W. Zimmerman
Kurt W. Zimmerman
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1062 Visits: 1396
You have to admit that is so lame.... FYI I've posted this bug on the Microsoft support website. Thanks for your suggestion.

Kurt

Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
grant-616287
grant-616287
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 22
I appreciate you submitting a bug to Microsoft on this issue. I hope you will post anything you find back to this forum as I too am suffering from this problem.

I have been having this problem for well over a year and it is beyond annoying. I am very diligent in how I put my database diagrams together, and I refer to them regularly throughout the software development process.

I've attached a BEFORE and AFTER jpg so that it is completely clear to anyone what is happening. In the BEFORE screen shot, you can see the entities all carefully placed within the page breaks. In the AFTER screen shot, all I have done is choose to PRINT the diagram. You can see the print dialog box open in this screen shot, and you can also see how ALL of the entities have mysteriously shifted down by about 1/2 a page.

I've tried to "outsmart" the shift, thinking OK, if it wants to shift 1/2 a page, I'll choose PRINT a 2nd time to see if it will shift again. Problem now is that it doesn't shift anymore. It stays "perfectly" misaligned.
Attachments
BEFORE.jpg (30 views, 131.00 KB)
AFTER.jpg (22 views, 220.00 KB)
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)SSC-Forever (44K reputation)

Group: General Forum Members
Points: 44964 Visits: 39862
It's certainly not a fix but there IS a work around...

The "problem" is that the printed version treats all 6 pages as if it were a "single page" and tries to center the entire diagram on that "single page". The work around is to put one item close to the top of that "single page" and one item near the bottom. It doesn't even have to be anything significant... a sparsley filled text box with the date and the author's name (you DO do such things, don't you? ;-)) wil suffice.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
     Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is usually not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Mike Bourgeois
Mike Bourgeois
SSChasing Mays
SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)SSChasing Mays (622 reputation)

Group: General Forum Members
Points: 622 Visits: 958
Are you going into File / Page Setup to set the correct paper size while you're using the diagram?

I've had my page breaks move when previewing them using my default "Letter" size & then selecting 11 x 17 in the printer preferences when actually printing.

My apologies if you're well past this point.
paul.jones
paul.jones
Old Hand
Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)Old Hand (378 reputation)

Group: General Forum Members
Points: 378 Visits: 730
My work-around is,

Zoom to 100%
right-click on the diagram
select "Copy Diagram to Clipboard"
Paste into MS Word or similar
Print it from there.

If the diagram needs to span multiple pages I've also tried pasting into Excel so I can set the page breaks.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search