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.1.1.2447

Package test results are passing.

This package was approved as a trusted package on 6/5/2018.

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 Pro - Compare and synchronize database schema
  • SQL Data Compare Pro - 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.
  • DLM Automation - Continuous integration and automated deployments for your SQL Server database
  • 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 Comparison SDK - Automate comparison and synchronization tasks
  • ReadyRoll - Develop and deploy databases in Visual Studio with migration scripts
  • SQL Monitor - SQL Server performance monitoring and alerting
  • SQL Backup Pro - Compress, securely encrypt and strengthen backups - fast

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

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

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

C:\> choco install sqltoolbelt --version 2.1.1.2447

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

C:\> choco upgrade sqltoolbelt --version 2.1.1.2447

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/04Jun2018/SQLToolbelt.exe'
    $packageVersionLastModified = New-Object -TypeName DateTimeOffset 2018, 6, 4, 11, 12, 24, 0 # Last modified time corresponding to this package version
    $checksum = 'D2DC3500E8460F20480CDF9C2F4FBD139E667E718EAF6B13B63E578743557402'
    
    $pp = Get-PackageParameters
    
    if ($pp["FTP"] -ne $null -and $pp["FTP"] -ne '') { 
    
      # FTP forced  
        $url = $secondaryDownloadUrl
    } else {
    
      # Red Gate have 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) {
        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"
        $url = $primaryDownloadUrl
      }
    }
    
    $packageArgs = @{
      packageName   = $env:ChocolateyPackageName
      fileType      = 'exe'
      silentArgs    = "/IAgreeToTheEula"
      
      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 172 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 59 Friday, April 26, 2019 approved
SQL Toolbelt 2.3.1.2605 132 Wednesday, April 3, 2019 approved
SQL Toolbelt 2.3.1.2601 69 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