How to Print SQL Doc as Data Dictionary

RobertMcDaniel

Is there a way to print the entire document from SQL Doc as one Data Dictionary?

Robert C

Hi,

I'm afraid there isn't a direct way of doing this, as we generate a seperate page for each database object. However, the following may be of help...

Internet Explorer has an option in the print dialog to "Print All Linked Documents". If you generate documentation using the "HTML with frames" style (default), open the HTML file for the left-hand navigation frame ("tree.html"), and then print that, choosing to print all linked documents. This should print all the individual database object pages.

Unfortunately Internet Explorer chooses to do this by printing each page as a separate print job, rather than concatenating them all into one, which means this isn't very useful if you're trying to output to PDF, for example.

(Note: you may wish to try this having documented only a small number of database objects the first time, as it could result in a large number of pages being printed!)

Hope that help,
Robert

gamblrg

Is there still no way to print the entire document from SQL Doc as one Data Dictionary?

The last post on the (Posted: Wed Nov 29, 2006 9:03 pm Post subject: How to Print SQL Doc as Data Dictionary), stated that there was direct way of doing this. Is that still the case?

Robert C

Hi,

There's still no way of generating a single page of output, but what has change since then is that SQL Doc 1.1 and later are able to export to CHM (compiled help) format.

If you do that, you can then chose to print "this topic and all sub-topics" from within the help viewer, which might achieve the results you're looking for.

Hope that helps,
Robert

russella0

Please can we have the ability to export to a pdf file - it would really help - it seems a bit of a glaring ommission in the product that there's no support at all for printing ?

David Atkinson

We plan to implement save-to-pdf functionality and this is currently penned to the v2 release, although I can't yet provide an ETA.

However, it is clear that a printable 'page' will have limited width so we will have to consider layout options, allowing the user to restrict the information that is provided so it fits neatly on a page. Is there any information that is currently there that you don't care about, or you would like to optionally turn off? If so, please let us know so we can take this into account when implementing the feature.

Kind regards,

David Atkinson
Product Manager
Red Gate Software

Charles Brown

SQL Doc 2.0 has just been released and includes support for fully printable Word .doc output, which can also be easily converted to pdf preserving all formatting and linkage.

Please see http://www.red-gate.com/messageboard/vi ... php?t=8150 for the full announcement.