+181
Accepted

Print OR Export database diagram to PDF/PNG

Support 12 months ago • updated by falk.wegener77 1 week ago 40 13 duplicates

User should be able to print or export database diagram.

Answers

+1
Answer
Accepted

Print & Export diagram to PDF or image is not implemented in SqlDBM as of yet. We have this task in our backlog.


Thank you for your assistance,

SqlDBM Team


-2
Answer
Under review

Print & Export diagram to PDF is not implemented in SqlDBM as of yet. We have this task in our backlog.

Duplicates 13

+26

This site has the best aesthetic design! it would be great to directly export database models to a PDF or HD image

+9

I have the same idea

+7

Was coming here to suggest the same.

+7

Was coming here too, to suggest the same. :)

+1

Any idea when this is going to be pushed out/if it is a priority? This service is amazing, but this would be the absolute icing on the cake.

+2

For now, this site is useful for me to design a sql models to create migrations in laravel, for the images I use a screenshot

+2

+1, this is a critical feature imo

+2

I wanted also to suggested the same.

This is really a very important feature!

Accepted

Print & Export diagram to PDF is not implemented in SqlDBM as of yet. We have this task in our backlog.

+1
Under review

Thank you for feedback, we will review this ticket soon

Under review

Thank you for feedback, we will review this ticket soon

+1
Answer
Accepted

Print & Export diagram to PDF or image is not implemented in SqlDBM as of yet. We have this task in our backlog.


Thank you for your assistance,

SqlDBM Team


+4

I have a workaround is a bit tricky:

  • After modelling set the the zoom of the viewer in 80% and preview the top left corner of your diagram.
  • Open the inspector of chrome dev tools and copy the node: board-diagramcontainer
  • Create a html file with the following content replacing with the node previous copied

<link rel="stylesheet" href="https://app.sqldbm.com/Content/css?v=6_w6CUqylHYnl8ZW9cH5Wg2c7P4fBy8MYd4Ic4Qk37U1"/>

<link rel="stylesheet" href="https://app.sqldbm.com/Components/css?v=AlQ3ih9LGYJh6RPCuU3DcG8Kf7-lyIBhNa5h0Jtd3q81"/>

<link rel="stylesheet" href="https://app.sqldbm.com/Content/dark-theme?v=hbDl4bnmFSiI8TMgXafhLkY-o3UkcdVuVFMcAMtzfcE1"/>

<style>

.erContainer .erTable table td {

    font-size: 8pt;

    padding: 0 3.5pt;

    line-height: 8.5pt;

}

.erContainer .erTable .erTableContent{

    padding: 4pt;

}

</style>

<pagebody>

<stage>

<board>

    <board-diagramcontainer>

        A LOT OF CONTENT HERE

    </board-diagramcontainer>

</board>

</stage>

</pagebody>


Thats, it!  


Thank you!  It help me a lot,

Thank you very much! You save me :) 

I would make sure that the export options include the following:  PNG,  SVG,  JPEG and PDF.

+2

I have spent some time reviewing a number of tools to manage database diagrams.  From a functional perspective SqlDBM is fantastic EXCEPT for 2 features:

1) You can't actually output the diagrams - to be honest that's hopeless

2) The table relationships are not labelled so you can not easily tell which columns are forming the relationships


Whilst Sergio's suggestion sort of works (you need to fiddle the margins depending on the size of the diagram) we are trying to diagram a database with +/- 300 tables that are divided in to 15-20 diagrams so copy & paste of HTML is not really a solution.


I appreciate printing is on you backlog, but how long is the backlog?  If it is really or in the 'never never' list then I will move on to one of your competitors.


Dear User,

Thank you for using SqlDBM and glad you liked it, also very much appreciate your analysis.

We agree with you that "Print" is very important functionality and must be available in any tool.


So far, we have been focusing on straightening out some key Database modelling features like Undo functionality, improving performance to have larger databases, types of indexes support etc.


Also, we are planning soon to have some kind of Road Map page on the website, so that it is transparent to all our users what we working on and what is coming next. 



Since Road Map page is not out yet, I will take this opportunity to list next few big features that are on horizon:


1) Currently we working on MySql Reverse Engineering, as well as better way to Reverse Engineering using DDL Script. One of the reasons to work on Reverse Engineering is a lot of users donated us money at https://sqldbm.com/en/Pricing/  and bumped priority for  Reverse Engineering improvements. 
I would like to take this opportunity to thank all users who donated money for their input into the project, which helped us to  hire additional developer, who is working on Reverse Engineering. 
 

2) Next: Work on moving from "Beta SqlDBM" to "SqlDBM". Many companies/users have mentioned that since we are in Beta, they want to wait until we have release version. Hence, that is important step for us.


3) Next: Print. As mentioned earlier we realize that it is important to have diagram in printable format. 



I hope that I have answered your question. Please feel free to contact us in case you have more questions.


Thanks
Team - SqlDBM

+4

Support,


Thanks for that response, so in terms of time does that mean printing is 3 weeks away, 3 months away or further out?


Cheers


John

-1

Dear User,

Based on current backlog (as I mentioned above) and size of tickets, for now it seems like Print will be done between 2 to 3 months.


Thanks
Team - SqlDBM

+1

Dear Support,
The last comment says 2 to 3 months, and that comments was 2 months back. Any further update on this feature? I would like to see that in action before deciding to stay with this tool.

Thanks

Mubin

-1

Dear Mubin,

  

  Thank you for using SqlDBM.


We recently launched a Release Version which includes different type Subscription plans. Currently, we are supporting lots of user requests, helping users to subscribe with paid plans.

We do understand that Print is important and as we have mentioned earlier, Print is in the immediate pipeline but we cannot promise on the timeline of its delivery. 

It is absolutely your call to stick with SqlDBM or not, but I would like to inform (in case you missed), we have offered great launch discount for all our users, which is limited time offer and it allows users to lock down the price forever.


Thanks,

Team - SqlDBM

+2

Team SqlDBM,

The price isn't really relevant if fundamentally the product doesn't have the functionality that a customer, or prospective customer sees as critical.  This issue is 7 months old and there are 6 related issues around diagram output, so it is not like I am alone on this requirement.

In response you have gone form a timeline of '2-3 months' to now not being able to specify a delivery date so really I have no idea when, if ever I would be able to output a diagram.  I don't see value even with a discounted price to be honest.

Its a shame, fundamentally I like the product but not being able to output a diagram is show stopper.


Good luck, I hope you are successful with your product.


Cheers


John

+2

This sort of response from SqlDBM also makes me wonder if it's under active development. Probably not if those are the timelines. A shame.

+5

I agree. This feature is required for this tool to be of use to me, and I'm reluctant to spend company funds on a subscription until I can see that it has been implemented in a useful way.


There also needs to be better routing of the connecting lines; currently they are a mess on complicated diagrams.

At the moment, in order to print this diagram I need to take screenshots, paste them into paint or somesuch to piece it back together, and THEN save to PDF. This is too time consuming so at the moment I can't really distribute the schemas I make here to other members of my team. The 'share' is not quite up to par either - the 'read only' view is the same as the editing view so there is too much going on on-screen for it to be user-friendly enough for our reporting analysts.

+1

Has this been added already, is it really that hard of a thing to do?

+1
My company wants to use this tool but if it does not have how to export will not be useful.
+1

What was said above. Nice system but without a print/export it is useless.

Is there no indication at all of when even a basic export/print feature might be added? This has been requested for over a year now and your updates are poor.

-2

Dear User,

Thanks for using SqlDBM.

We agree Print functionality is very important and that is why it is on top of our priority list and we are working towards it.


After investigation we figured, in order to do it correctly, it would require big code refactoring.

But this refactoring would also give us other UI benefits as well, such as Auto Layouts , crow foot notation etc.


Hope it helps.


Again thank you being valuable user of SqlDBM

-1

I use this workaround with the library https://html2canvas.hertzen.com/ 

Open a javascript console and paste this code. This will open a new tab with the image you can save.

fetch('https://html2canvas.hertzen.com/dist/html2canvas.min.js')
   .then(response => response.text())
   .then(text => eval(text))
   .then(() => {
           var pspace = document.getElementsByClassName('printSpace')[0]
           var w = pspace.width.baseVal.value;
           var h = pspace.height.baseVal.value;
           html2canvas(document.getElementsByTagName('board-diagramcontainer')[0], {width: w, height: h}).then(canvas => {
           var newTab = window.open();
        newTab.document.body.innerHTML = '<img src="'+ canvas.toDataURL() +'">';
    });
});

Of course, use this code under your responsibility. I only tested with chrome.

-2
Answer
Under review

Print & Export diagram to PDF is not implemented in SqlDBM as of yet. We have this task in our backlog.

+2

We are looking at paying for SQLDBM at our company, but with no print functionality, this service is basically useless to us. We are also very discouraged from paying for this product after seeing how often this basic functionality has been pushed back. 

Seems like a basic thing that is taking way too long. 

Just found out, that there is no way to print complex diagrams larger than a screen size.

Perfect would be a poster print option (via multipage PDF or TIFF). I have now a quite large diagram and it's not easy to show the diagram as a whole big picture for final presentation.


Has there been any progress about this topic since the last 7 months?

A large TIFF or PDF with a single picture/page would work the beginning, too. Then I could use other poster print software.

The only viable option I can use so far, is to create a database diagram in SSMS, after i have exported the SQLDBM-diagram as SQL-Code and import the code in a test database. But I loose all the colors, text boxes, diagram layout... . But this option only works for Microsoft databases and if the diagram is already complete and exportable (yes, it happens sometimes, that draft diagrams generate not get the right SQL-Code, because of some missing PK FK,..... Thats' why it's a draft and need to be discussed and checked in a meeting with a big picture print out.)