Wednesday , December 7 2022

Upgrade Powershell DbaTools Module

You may be using the DbaTools module for SQL Server administration with Powershell. So how do we Upgrade the Powershell DbaTools Module and what is the version of the dbatools module you are using, I will be telling you about them in this article.

First of all, dbatools must be installed. If it is installed, we can learn the version information with the following command.

As you can see in the picture, we are using version 0.9.834, so how do we use the new version? (You can see the version histories from the link below)

Opening a powershell as an administrator and running the following command will be enough for you to upgrade.

The output of the command is as follows.

After the process is complete, let’s do the version check again.

As you can see in the picture above, we have successfully upgraded the dbatools module. The most important improvement is that the Azure connection is now available with this version.

We can now also manage our Azure databases using Powershell and DbaTools. In addition, 13 new commands have arrived. The list of newly added commands is as follows.

Add-DbaDbRoleMember

Get-DbaDbRole

New-DbaDbRole

New-DbaInstanceRole

Remove-DbaDbRole

Remove-DbaDbRoleMember

Remove-DbaInstanceRole

About Çağlar Özenç

Leave a Reply

Your email address will not be published. Required fields are marked *