Automated Database Documentation

agbush

Hello
I was wondering if its possible to schedule the creation of database documentation on a periodic basis (ie weekly)
Im looking to make this a server based processes, fully automatic with no human intervention

Sergio R

Hi,

Yes, this should be possible by using the SQL Doc command-line tools with the Windows task scheduler:
https://documentation.red-gate.com/sdoc/using-the-command-line

Kind Regards,

Phil_Factor

It is an excellent way of using SQL Doc. I give several examples of how to do this in PowerShell here on the site. See: https://www.red-gate.com/hub/product-learning/sql-doc