Red Gate forums :: View topic - SQL Doc API?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Doc 1
SQL Doc 1 forum

SQL Doc API?

Search in SQL Doc 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbaadm



Joined: 09 May 2005
Posts: 4

PostPosted: Wed Jul 25, 2007 9:54 am    Post subject: SQL Doc API? Reply with quote

Would it possible to create ones own batch application with help of the SQL Doc API in order to automatic documentation of multi servers/instances?

Here I think in the lines of how the API for SQL Compare works.

The reason I would like to have only one compiled Microsoft HTML Help (.chm file) for a system that are located on more then one server.

I would like to be able to select on high object level (Database – Tables, Views Programmability and Security), what’s should in the .chm file.

I know that I could use the command line feature that’s comes with the Pro version, but is builds one file pr server and then merge the .chm files into one.
But it would be nice if I could use the SQL Doc API, since I now have the Pro version.
Back to top
View user's profile Send private message
chris.buckingham



Joined: 30 Jul 2007
Posts: 56

PostPosted: Mon Jul 30, 2007 2:36 pm    Post subject: Reply with quote

I'm afraid that there isn't a SQL Doc API that you can use, but it is possible to call a sequence of SQLdoc sessions by using a batch file calling the SQL Doc command line for each project.

You have to set up each project file first using the GUI, setting a target directory for each project, with source databases, passwords etc. The batch file can then call a CHM publisher through a command line to write CHM files using each target directory as a source. Simple root level html code would have to be written to call the 'index.html' from each target directory so that a tree structure would be displayed - however that would only have to be created once

The help file in SQL Doc under 'Using the Command Line' explains the command line syntax.
_________________
Chris Buckingham
Red-Gate support
Back to top
View user's profile Send private message Send e-mail
dbaadm



Joined: 09 May 2005
Posts: 4

PostPosted: Tue Jul 31, 2007 11:58 am    Post subject: Reply with quote

Thanks.
You input works partly. I looks like if the SQL Doc Application has been open and the output style has been changed to an outer style it's the "new" style the output saves - no matter the project file state the OutputStyle should be Sad
I think that must be a bug or….
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1114
Location: Twitter: @dtabase

PostPosted: Sun Nov 18, 2007 10:09 pm    Post subject: Reply with quote

Hi,

The output style option is an application-level option, rather than a project-level option. Do you require different output styles depending on your project? If so I will raise this as an enhancement request. I would be interested to know any reasons behind this, as this would add weight to the request.

Best regards,

David Atkinson
Red Gate Software
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group