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.

Thanks for reading!

Agree or disagree? Have I missed something, or do you want to add anything? Share your views in the comments below:

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments

Want to learn about Microsoft Data Platform?

Check out the community events page for more events.

Next Upcoming Event
29 November 2021
  • 00

    days

  • 00

    hours

  • 00

    minutes

  • 00

    seconds

Enter your email address to subscribe to this blog and receive notifications of new posts by email. No spam, promise, and you can unsubscribe anytime. Alternatively, you can subscribe via RSS

Windocks
0
Would love your thoughts, please comment.x
()
x