Specification of argfile parameter

[benseaman]

Hi,

I see from the command-line help for SQLDoc there is an argfile parameter as with the other tools however I cannot find any help topics on the Red Gate website for this. Could someone please point me in the direction of this? Essentially i want to pick the server and database dynamically without having to creating a project.

thanks

Ben

[james.billings]

Thanks for posting.

The argfile parameter, unfortunately, doesn't offer anything else than the other switches. We do have an internal 'bug' for the lack of documentation around it, but essentially, the same options can be used in the argfile as you can pass anyway.

So you could have an XML argfile containting, for instance:

<?xml version="1.0"?>
<commandline>
<project>MyProject.sqldoc</project>
<force />
</commandline>

but NOT

<?xml version="1.0"?>
<commandline>
<server>DevSvr</server>
<database>OrdersDB</database>
<force />
</commandline>

Therefore the argfile isn't much more useful.
I think the only way you could automate dynamically supplying the server and db would be to write a cleverer batch file that could take input and pass on the variables to the SQL Doc command.