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.
Installation
Install-DbaSqlWatch -SqlInstance SQL-TEST-1,SQL-TEST-2,SQL-TEST-3 -Database SQLWATCH
Watch the below example:
Update
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.
Remove
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 (github.com/koglerk) for contributing the Install-DbaSqlWatch
.
This post was originally published on 18th May 2020.
Recent Posts
Want to learn about SQLWATCH?
Marcin Gminski2023-03-28T22:07:01+01:0028th March 2023|0 Comments
SQLWATCH 4.4
Marcin Gminski2022-10-06T15:32:56+01:006th October 2022|0 Comments
T-SQL Tuesday #147 – SQL Server Upgrade Strategies
Marcin Gminski2023-07-06T23:15:07+01:008th February 2022|0 Comments
Should we run SQL Server on the default port 1433
Marcin Gminski2022-03-25T12:40:05+00:007th February 2022|3 Comments
Happy New Year!
Marcin Gminski2022-01-01T18:28:43+00:001st January 2022|0 Comments
I am a Microsoft MVP!
Marcin Gminski2021-12-02T23:15:16+00:002nd December 2021|10 Comments