Deploy SQLWATCH with dbatools

I am happy to announce that thanks to our fantastic SQL Server Community it is now possible to deploy SQLWATCH using dbatools. If you work with SQL Server and are not familiar with dbatools you should check it out now, it will change your DBA life forever.

With dbatools we can now streamline deployments and updates of SQLWATCH across the entire SQL Server estate in a matter of minutes.


Install-DbaSqlWatch -SqlInstance SQL-TEST-1,SQL-TEST-2,SQL-TEST-3 -Database SQLWATCH

Watch the below example:


Behind the scenes, the deployment is done using dacpac and operates on the desired state configuration approach which means it will work out what needs to be done to bring the database to the latest version. To update SQLWATCH all we have to do is to re-run the install as in the step above.


Removal is equally easy:

Uninstall-DbaSqlWatch -SqlInstance SQL-TEST-2

Thank you #sqlamily

Finally, I would like to thank Chrissy LeMaire for dbatools and Ken K ( for contributing the Install-DbaSqlWatch .

Originally posted on 12th February 2019 @ 20:18

Table of Contents
Marcin Gminski

Marcin Gminski

Following his degree in Telecommunications Engineering and Information Technology, Marcin has gained over 20 years’ experience and knowledge of the SQL Server administration, Data Migrations, E2E performance testing and tuning, database development life cycle covering technical architecture, data analysis, logical and physical design including disaster recovery, specification, coding, implementation, and support. Marcin has delivered data migration projects in banking, retail, automotive and medical industries.
This site, like most websites, uses cookies. By continuing to use this website, you agree to their use.