SQL Change Automation 4

Installing PowerShell components

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:

Install-Module SqlChangeAutomation

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:

Update-Module SqlChangeAutomation

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.

For more information see the documentation on Install-Module and Update-Module

Installing from SQL Toolbelt

If you cannot use PowerShellGet you can also install using the SQL Toolbelt

Unattended installation

SQLToolbelt.exe /IAgreeToTheEULA

Didn't find what you were looking for?