How to Print SQL Doc as Data Dictionary

Documents SQL Server 2000, 2005 and 2008 databases.


Moderators: David Atkinson, david connell, Charles Brown

How to Print SQL Doc as Data Dictionary

Postby RobertMcDaniel » Wed Nov 29, 2006 10:03 pm

Is there a way to print the entire document from SQL Doc as one Data Dictionary?
RobertMcDaniel
 
Posts: 1
Joined: Wed Nov 29, 2006 10:00 pm

Postby Robert » Thu Nov 30, 2006 10:04 am

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
Developer, Red Gate Software Ltd
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK

SQL Doc: Print Entire Dictionary

Postby gamblrg » Fri Feb 08, 2008 7:56 pm

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?
gamblrg
 
Posts: 1
Joined: Fri Feb 08, 2008 7:44 pm

Postby Robert » Fri Feb 08, 2008 9:24 pm

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
Developer, Red Gate Software Ltd
Robert
 
Posts: 410
Joined: Mon Oct 30, 2006 11:15 am
Location: Cambridge, UK

Postby russella0 » Fri May 16, 2008 8:29 am

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 ?
russella0
 
Posts: 5
Joined: Wed Oct 03, 2007 5:29 pm

Postby David Atkinson » Fri May 16, 2008 11:27 am

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
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase

Postby Charles Brown » Thu Dec 18, 2008 4:02 pm

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
Charles Brown
 
Posts: 8
Joined: Thu Jun 12, 2008 10:55 am


Return to SQL Doc 1

Who is online

Users browsing this forum: No registered users and 0 guests