Downloads of v


Last Update:

15 Feb 2019

Package Maintainer(s):

Software Author(s):

  • Red Gate Software Ltd


SQL Server SQL-Server Tools RedGate SqlToolbelt Toolbelt trial admin

SQL Toolbelt

This is not the latest version of SQL Toolbelt available.

  • 1
  • 2
  • 3 | Updated: 15 Feb 2019



Downloads of v



Software Author(s):

  • Red Gate Software Ltd

  • 1
  • 2
  • 3
SQL Toolbelt

This is not the latest version of SQL Toolbelt available.

  • 1
  • 2
  • 3

This Package Contains an Exempted Check

Not All Tests Have Passed

Validation Testing Passed

Verification Testing Passed


Scan Testing Exemption for this package version only:


To install SQL Toolbelt, run the following command from the command line or from PowerShell:


To upgrade SQL Toolbelt, run the following command from the command line or from PowerShell:


To uninstall SQL Toolbelt, run the following command from the command line or from PowerShell:


NOTE: This applies to both open source and commercial editions of Chocolatey.

1. Ensure you are set for organizational deployment

Please see the organizational deployment guide

  • Open Source or Commercial:
    • Proxy Repository - Create a proxy nuget repository on Nexus, Artifactory Pro, or a proxy Chocolatey repository on ProGet. Point your upstream to Packages cache on first access automatically. Make sure your choco clients are using your proxy repository as a source and NOT the default community repository. See source command for more information.
    • You can also just download the package and push it to a repository Download

3. Enter your internal repository url

(this should look similar to

4. Choose your deployment method:

choco upgrade sqltoolbelt -y --source="'STEP 3 URL'" [other options]

See options you can pass to upgrade.

See best practices for scripting.

Add this to a PowerShell script or use a Batch script with tools and in places where you are calling directly to Chocolatey. If you are integrating, keep in mind enhanced exit codes.

If you do use a PowerShell script, use the following to ensure bad exit codes are shown as failures:

choco upgrade sqltoolbelt -y --source="'STEP 3 URL'"

Write-Verbose "Exit code was $exitCode"
$validExitCodes = @(0, 1605, 1614, 1641, 3010)
if ($validExitCodes -contains $exitCode) {
  Exit 0

Exit $exitCode

- name: Ensure sqltoolbelt installed
    name: sqltoolbelt
    state: present
    source: STEP 3 URL

See docs at

chocolatey_package 'sqltoolbelt' do
  action    :install
  version  ''
  source   'STEP 3 URL'

See docs at

    Name: sqltoolbelt,
    Source: STEP 3 URL

Requires Otter Chocolatey Extension. See docs at

cChocoPackageInstaller sqltoolbelt
   Name     = 'sqltoolbelt'
   Ensure   = 'Present'
   Version  = ''
   Source   = 'STEP 3 URL'

Requires cChoco DSC Resource. See docs at

package { 'sqltoolbelt':
  provider => 'chocolatey',
  ensure   => '',
  source   => 'STEP 3 URL',

Requires Puppet Chocolatey Provider module. See docs at

salt '*' chocolatey.install sqltoolbelt version="" source="STEP 3 URL"

See docs at

5. If applicable - Chocolatey configuration/installation

See infrastructure management matrix for Chocolatey configuration elements and examples.

There are versions of this package awaiting moderation . See the Version History section below.

This package was approved as a trusted package on 15 Feb 2019.


Redgate's SQL Toolbelt contains the industry-standard products for SQL Server development, deployment, backup, and monitoring. Together, they make you productive, your team agile, and your data safe.

Thousands of SQL Server professionals rely on the SQL Toolbelt every day, because it’s reliable, easy to use, and plugs in to the tools they already use for application development.

Tools in the SQL Toolbelt:

  • SQL Compare - Compare and synchronize database schema
  • SQL Data Compare - Compare and synchronize database contents
  • SQL Source Control - Connect your databases to your version control system
  • SQL Prompt - Write, refactor, and explore SQL effortlessly
  • SQL Search - Search your database quickly in SQL Server Management Studio
  • SQL Data Generator - Generate realistic test data fast, based on column and table names
  • SQL Doc - Automatically generate database documentation
  • SQL Test - Write and run unit tests in SQL Server Management Studio
  • DLM Dashboard - tracks your database schemas and alerts you when they change.
  • SQL Multi Script - Deploy multiple scripts to multiple servers with just one click
  • SQL Dependency Tracker - Explore object dependencies and visualize complex databases simply
  • SQL Monitor - SQL Server performance monitoring and alerting
  • SQL Backup - Compress, securely encrypt and strengthen backups - fast
  • SSMS Integration Pack - Use SQL Compare and SQL Data Compare from SSMS
  • SQL Change Automation Powershell - Automates database development solutions
  • SQL Change Automation - Develop and deploy databases in Visual Studio with migration scripts

Package Download Fallback

This package will fallback to the Red Gate FTP site once the main fixed URL no longer matches the version for which this package was created. This is to ensure that a specific version of the Chocolatey package continues to work even after Red Gate releases newer versions.

When a newer version of the package is published, it will then revert to using the primary https download URL.

Package Parameters

The following package parameters can be set:

  • /FTP - Force using the FTP download URL
  • /NoFTP - Don't fallback to FTP if HTTPS modified time is different (using this risks a checksum mismatch if file is actually a newer version)
  • /products - Only install the specified products (see tools\chocolateyinstall.ps1 for supported named)

These parameters can be passed to the installer with the use of --params.
For example: --params "/FTP /products:'SQL Compare, SQL Data Compare'".

$ErrorActionPreference = 'Stop';
$toolsDir     = "$(Split-Path -parent $MyInvocation.MyCommand.Definition)"

$primaryDownloadUrl = ""
$secondaryDownloadUrl = ''
$packageVersionLastModified = New-Object -TypeName DateTimeOffset 2019, 2, 14, 13, 52, 6, 0 # Last modified time corresponding to this package version
$checksum = '6E929445ED49621BB31B7350FE2EF52AE4169324B3D1A85D5FB1A6FE648B1344'

$validProductPackageNames = @(
  "SQL Compare",
  "SQL Data Compare",
  "SQL Source Control",
  "SQL Prompt",
  "SQL Search",
  "SQL Data Generator",
  "SQL Doc",
  "SQL Test",
  "DLM Dashboard",
  "SQL Multi Script",
  "SQL Dependency Tracker",
  "SQL Monitor Installer",
  "SQL Backup",
  "SSMS Integration Pack",
  "SQL Change Automation Powershell",
  "SQL Change Automation" )

$pp = Get-PackageParameters

$commandArgs = ""
if ($pp["products"] -ne $null -and $pp["products"] -ne ''){

  $products = $pp["products"].Split(",")
  foreach($product in $products){
      throw "Invalid product package name '$product', exiting installer."

  $productCommand = "products ""$($pp["products"])"""
  $commandArgs += "$productCommand "
} else {

  $productCommand = "all products"

$commandArgs += "/IAgreeToTheEula"

$url = $primaryDownloadUrl

if ($pp["FTP"] -ne $null -and $pp["FTP"] -ne '') { 

  # FTP forced
  Write-Verbose "Using $secondaryDownloadUrl because /FTP was specified"
  $url = $secondaryDownloadUrl
} else {

  # Red Gate has a fixed download URL, but if the binary changes we can fall back to their FTP site
  # so the package doesn't break
  $headers = Get-WebHeaders -url $primaryDownloadUrl
  $lastModifiedHeader = $headers.'Last-Modified'

  $lastModified = [DateTimeOffset]::Parse($lastModifiedHeader, [Globalization.CultureInfo]::InvariantCulture)

  Write-Verbose "Package LastModified: $packageVersionLastModified"
  Write-Verbose "HTTP Last Modified  : $lastModified"

  if ($lastModified -ne $packageVersionLastModified) {
    if ($pp["NoFTP"]) {
      Write-Warning "The download available at $primaryDownloadUrl has changed from what this package was expecting, but /NoFTP package parameter was supplied. Expect checksums to fail if the download is actually a newer version."
    } else {
      Write-Warning "The download available at $primaryDownloadUrl has changed from what this package was expecting. Falling back to FTP for version-specific URL"
      $url = $secondaryDownloadUrl
  } else {
    Write-Verbose "Primary URL matches package expectation"

$packageArgs = @{
  packageName   = $env:ChocolateyPackageName
  fileType      = 'exe'
  silentArgs    = $commandArgs

  validExitCodes= @(0)
  url           = $url
  checksum      = $checksum
  checksumType  = 'sha256'
  destination   = $toolsDir

Install-ChocolateyPackage @packageArgs
$ErrorActionPreference = 'Stop';

# Empty placeholder uninstall script so that Chocolatey doesn't get confused by not being able to match the package name
# Auto-uninstall correctly uninstalls all individual applications in this bundle

Log in or click on link to see number of positives.

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.

Version Downloads Last Updated Status
SQL Toolbelt 2021.10.11 2653 Wednesday, October 13, 2021 Approved
SQL Toolbelt 2021.10.06 10 Friday, October 8, 2021
Waiting for Maintainer
SQL Toolbelt 2021.09.29 3314 Friday, October 1, 2021 Approved
SQL Toolbelt 2021.09.23 1774 Saturday, September 25, 2021 Approved
SQL Toolbelt 2021.09.22 559 Friday, September 24, 2021 Approved
SQL Toolbelt 2021.09.16 1753 Saturday, September 18, 2021 Approved
SQL Toolbelt 2021.09.09 2022 Saturday, September 11, 2021 Approved
SQL Toolbelt 2021.09.08 538 Friday, September 10, 2021 Approved
SQL Toolbelt 2021.09.02 1740 Saturday, September 4, 2021 Approved
Discussion for the SQL Toolbelt Package

Ground Rules:

  • This discussion is only about SQL Toolbelt and the SQL Toolbelt package. If you have feedback for Chocolatey, please contact the Google Group.
  • This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
  • The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
  • Tell us what you love about the package or SQL Toolbelt, or tell us what needs improvement.
  • Share your experiences with the package, or extra configuration or gotchas that you've found.
  • If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.
comments powered by Disqus