Notices: This section not yet converted to new layout. Download stats are rolling back out.

This is not the latest version of SQL Toolbelt available.

SQL Toolbelt

2.3.1.2605

Package test results are passing.

This package was approved as a trusted package on 4/3/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'".

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

C:\> choco install sqltoolbelt --version 2.3.1.2605

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

C:\> choco upgrade sqltoolbelt --version 2.3.1.2605

Files

Hide
  • tools\chocolateyinstall.ps1 Show
    $ErrorActionPreference = 'Stop';
    $toolsDir     = "$(Split-Path -parent $MyInvocation.MyCommand.Definition)"
    
    $primaryDownloadUrl = "https://download.red-gate.com/SQLToolbelt.exe"
    $secondaryDownloadUrl = 'ftp://support.red-gate.com/patches/SQLToolbelt/02Apr2019/SQLToolbelt.exe'
    $packageVersionLastModified = New-Object -TypeName DateTimeOffset 2019, 4, 2, 12, 9, 36, 0 # Last modified time corresponding to this package version
    $checksum = '486CB0E7CF14D09522EAE701FEB0F466DEDBA37524FE612B2D293B25C144CBCE'
    
    $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){
        if(!$validProductPackageNames.Contains($product.Trim())){
          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
    
  • tools\chocolateyuninstall.ps1 Show
    $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

Virus Scan Results

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.

Dependencies

Package Maintainer(s)

Software Author(s)

  • Red Gate Software Ltd

Copyright

2017 Red Gate Software Ltd

Tags

Release Notes

https://www.red-gate.com/products/roadmap

Version History

Version Downloads Last updated Status
SQL Toolbelt 2.3.2.2621 72 Wednesday, July 24, 2019 approved
SQL Toolbelt 2.3.2.2618 173 Friday, June 21, 2019 approved
SQL Toolbelt 2.3.1.2615 232 Wednesday, May 15, 2019 approved
SQL Toolbelt 2.3.1.2612 133 Wednesday, May 1, 2019 approved
SQL Toolbelt 2.3.1.2610 60 Friday, April 26, 2019 approved
SQL Toolbelt 2.3.1.2605 132 Wednesday, April 3, 2019 approved
SQL Toolbelt 2.3.1.2601 71 Friday, March 29, 2019 approved
SQL Toolbelt 2.3.1.2593 106 Tuesday, March 12, 2019 approved
SQL Toolbelt 2.3.1.2583 67 Thursday, March 7, 2019 approved
Show More

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
Chocolatey.org uses cookies to enhance the user experience of the site.
Ok