Installing PowerShell components
Published 31 July 2019
Installing from PowerShell Gallery
SQL Change Automation is available from the PowerShell Gallery. You'll need at least version 1.6 of the PowerShellGet module to install the SQL Change Automation module.
Install PowerShellGet 1.6 if necessary
Instructions on how to install PowerShellGet can be found on the Microsoft documentation site. If you're using PowerShell 5 or greater, you can run the following in an elevated PowerShell session:
Install-PackageProvider NuGet -Force Exit
then, in a new elevated PowerShell session, run the following to install the latest PowerShellGet:
Install-Module PowerShellGet -MinimumVersion 1.6 -Force Exit
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 https://github.com/PowerShell/PowerShellGet/issues/246).
Install the SqlChangeAutomation module
Run the following in an elevated PowerShell session:
Updating the SqlChangeAutomation module
To update the SqlChangeAutomation module to the latest version available on the gallery, run the following in an elevated PowerShell session:
Installing or updating as part of an automated build/release script
The instructions above require an elevated PowerShell session, and will prompt you to accept the license for SqlChangeAutomation before installing it. If you're installing and/or updating as part of an automated process, you can install the module in the current user scope, and accept the license as part of the installation. To do this, run the following scripts instead:
Install-Module SqlChangeAutomation -Scope CurrentUser -AcceptLicense
Update-Module SqlChangeAutomation -AcceptLicense
By adding the
-AcceptLicense argument, you are confirming that you accept the license agreement for SqlChangeAutomation as detailed in the Redgate standard EULA. If you do not wish to be bound by that license, do not install the SqlChangeAutomation module.
Installing from SQL Toolbelt
If you cannot use PowerShellGet you can also install using the SQL Toolbelt