

To update the SqlChangeAutomation module to the latest version available on the gallery, run the following in an elevated PowerShell session: Update-Module SqlChangeAutomation Installing or updating as part of an automated build/release script Run the following in an elevated PowerShell session: Install-Module SqlChangeAutomation Updating the SqlChangeAutomation module It's important that you exit the PowerShell session each time, otherwise the wrong versions of the package management module and/or package provider might be used (see, for example, the issues documented in ). Then, in a new elevated PowerShell session, run Install-Module to install the latest PowerShellGet: Install-Module PowerShellGet -MinimumVersion 1.6 -Force -AllowClobber If you're using PowerShell 5 or greater, you can run the following in an elevated PowerShell session: Install-PackageProvider NuGet -Force Instructions on how to install PowerShellGet can be found on the Microsoft documentation site. You'll need at least version 1.6 of the PowerShellGet module to install the SQL Change Automation module. SQL Change Automation is available from the PowerShell Gallery. Method 1: Installing and Upgrading from PowerShell Gallery Please note that this does NOT require uninstalling the entire SQL Toolbelt, only the "SQL Change Automation PowerShell" program. Reinstall the program using the desired methodology from the list below.Search for "SQL Change Automation PowerShell" in the list.Open "Add or Remove Programs" in System Settings (or Run: appwiz.cpl).If you wish to change the way you update SQL Change Automation PowerShell components from one of these methods to the other, you may do so at any time SQL Change Automation PowerShell components may be installed and upgraded in two waysĪ key thing to understand is that the way SQL Change Automation PowerShell components are installed is the way you will upgrade themįor example, if you installed the PowerShell components from the SQL Toolbelt installer and you attempt to upgrade them from the PowerShell Gallery, you will see an error message: Module 'SqlChangeAutomation' was not installed by using Install-Module, so it cannot be updated.
