Downloads:

20,453

Downloads of v 2.0.1.2209:

198

Last Update:

13 Dec 2017

Package Maintainer(s):

Software Author(s):

  • Red Gate Software Ltd

Tags:

SQL Server SQL-Server Tools RedGate SqlToolbelt Toolbelt trial admin

SQL Toolbelt

This is not the latest version of SQL Toolbelt available.

2.0.1.2209 | Updated: 13 Dec 2017

Downloads:

20,453

Downloads of v 2.0.1.2209:

198

Maintainer(s):

Software Author(s):

  • Red Gate Software Ltd

SQL Toolbelt 2.0.1.2209

This is not the latest version of SQL Toolbelt available.

All Checks are Passing

2 Passing Test


Validation Testing Passed


Verification Testing Passed

Details

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 https://chocolatey.org/api/v2. 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 https://chocolatey.org/api/v2)

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'" 
$exitCode = $LASTEXITCODE

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

Exit $exitCode

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

See docs at https://docs.ansible.com/ansible/latest/modules/win_chocolatey_module.html.

Coming early 2020! Central Managment Reporting available now! More information...


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

See docs at https://docs.chef.io/resource_chocolatey_package.html.


Chocolatey::Ensure-Package
(
    Name: sqltoolbelt,
    Version: 2.0.1.2209,
    Source: STEP 3 URL
);

Requires Otter Chocolatey Extension. See docs at https://inedo.com/den/otter/chocolatey.


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

Requires cChoco DSC Resource. See docs at https://github.com/chocolatey/cChoco.


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

Requires Puppet Chocolatey Provider module. See docs at https://forge.puppet.com/puppetlabs/chocolatey.


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

See docs at https://docs.saltstack.com/en/latest/ref/modules/all/salt.modules.chocolatey.html.

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 13 Dec 2017.

Description

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'".


tools\chocolateyinstall.ps1
$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/12Dec2017/SQLToolbelt.exe'
$packageVersionLastModified = New-Object -TypeName DateTimeOffset 2017, 12, 12, 17, 21, 55, 0 # Last modified time corresponding to this package version
$checksum = '506FB47B48097CFC95BDBA3F8A834506491F782296FD40DDE5B1700B23CFF582'

$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
$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

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 2019.12.02 0 Tuesday, December 3, 2019 Approved
SQL Toolbelt 2019.11.28 21 Friday, November 29, 2019 Approved
SQL Toolbelt 2019.11.27 15 Thursday, November 28, 2019 Approved
SQL Toolbelt 2019.11.26 6 Wednesday, November 27, 2019 Waiting for Maintainer
SQL Toolbelt 2019.11.25 23 Tuesday, November 26, 2019 Approved
SQL Toolbelt 2019.11.21 38 Friday, November 22, 2019 Approved
SQL Toolbelt 2019.11.20 6 Thursday, November 21, 2019 Waiting for Maintainer
SQL Toolbelt 2019.11.19 35 Wednesday, November 20, 2019 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