What are the challenges you face when working across database platforms? Take the survey
Options

How to Print SQL Doc as Data Dictionary

RobertMcDanielRobertMcDaniel Posts: 2
edited December 18, 2008 10:02AM in SQL Doc Previous Versions
Is there a way to print the entire document from SQL Doc as one Data Dictionary?

Comments

  • Options
    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
    Robert Chipperfield
    Red Gate
  • Options
    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?
  • Options
    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
    Robert Chipperfield
    Red Gate
  • Options
    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 ?
  • Options
    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
    David Atkinson
    Product Manager
    Redgate Software
  • Options
    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.
    Charles Brown
    Red Gate Software
Sign In or Register to comment.