running as scheduled task not adding new databases

Documents SQL Server 2005 and 2008 databases.

Moderators: JonathanWatts, David Atkinson, Michelle Taylor

running as scheduled task not adding new databases

Postby bn2hunt » Thu Aug 20, 2009 3:53 pm

I am running the following scheduled task in Vista 32 bit.

program : "C:\\Program Files\\Red Gate\\SQL Doc 2"
arguments : \\SQLDoc.exe /project:"C:\\Users\\dan-w\\Documents\\My Database Documentation\\reef.sqldoc" /filetype:html-frames

If I don't go in and update the project to include all the databases it will not document any new databases that have been created. Is there a way to do this that will document every database on the server?

Thanks

Dan
bn2hunt
 
Posts: 3
Joined: Mon Mar 09, 2009 1:56 pm

Postby Brian Donahue » Fri Aug 21, 2009 5:47 pm

Hi Dan,

At the moment, the command-line SQL Doc supports running projects created with the UI version of SQL Doc. This doesn't give you the opportunity to dynamically add databases to the list of databases that get documented.

We can look into this for a future version of SQL Doc.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby bn2hunt » Fri Aug 21, 2009 9:00 pm

Is there a different way to pull the documentation for every database?
bn2hunt
 
Posts: 3
Joined: Mon Mar 09, 2009 1:56 pm

Postby Brian Donahue » Mon Aug 24, 2009 1:48 pm

SQL Doc requires that the databases and servers are added in the User Interface. I haven't got any unsupported hack or any other way to do it automatically when a new database is added.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Doc 2

Who is online

Users browsing this forum: No registered users and 0 guests