Search code examples
entity-relationshipmysql-workbench

MySQL WorkBench EER diagram dimensions are terrible


I am using MYSQL workbench to generate an EER diagram, and to the best of my knowledge, one can not control the dimensions of the canvas, only the size in number of pages. This has the result that you get a huge amount of white space around your diagram, making it nearly unusable. Why anyone would design it this way is beyond me. There are a lot of questions which ask how to crop a pdf, but they are either more complicated (ie. crop to a certain dimension, or crop and output to different format and ratio) or they do not preserve the image quality, or they just plain do not work. My question therefore is this:

enter image description here

How does one create or convert an EER diagram using MySQL Workbench such that there are no white borders AND the image quality is preserved?

Note I asked the question here as it pertains to databasing, but apologies if it is in the wrong place.


Solution

  • Looks like what you are after is a way to limit the output of an image export to a relatively small area, so that it fits nicely in another document. Several options are possible:

    1) Export as png and simply cut off the unwanted parts. Depending on the further usage this might be good enough.

    2) Export as SVG and use any of the SVG editors to limit the image size to the wanted area only. Then convert it to the format you need in your target document.

    3) Set a paper size in the model that encompasses the content as close as possible. E.g. the statement paper type is quite small. Then rearrange your objects. Resize them if you need larger ones. By setting a larger font (via Preferences) you should be able to make the entire appearence larger. Then export as PDF.