Downloads:

1,011

Downloads of v 1.5.0:

544

Last Update:

21 Nov 2017

Package Maintainer(s):

Software Author(s):

  • Istvan Bialko

Tags:

rs ssms extension custom scripts admin

RS.SSMS.Extension

1.5.0 | Updated: 21 Nov 2017

Downloads:

1,011

Downloads of v 1.5.0:

544

Maintainer(s):

Software Author(s):

  • Istvan Bialko

Tags:

rs ssms extension custom scripts admin

RS.SSMS.Extension 1.5.0

All Checks are Passing

2 Passing Test

Validation Testing Passed

Verification Testing Passed

Details

To install RS.SSMS.Extension, run the following command from the command line or from PowerShell:

>

To upgrade RS.SSMS.Extension, run the following command from the command line or from PowerShell:

>

To uninstall RS.SSMS.Extension, 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 rs-ssms-extension -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 rs-ssms-extension -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 rs-ssms-extension installed
  win_chocolatey:
    name: rs-ssms-extension
    state: present
    version: 1.5.0
    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 'rs-ssms-extension' do
  action    :install
  version  '1.5.0'
  source   'STEP 3 URL'
end

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


Chocolatey::Ensure-Package
(
    Name: rs-ssms-extension,
    Version: 1.5.0,
    Source: STEP 3 URL
);

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


cChocoPackageInstaller rs-ssms-extension
{
   Name     = 'rs-ssms-extension'
   Ensure   = 'Present'
   Version  = '1.5.0'
   Source   = 'STEP 3 URL'
}

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


package { 'rs-ssms-extension':
  provider => 'chocolatey',
  ensure   => '1.5.0',
  source   => 'STEP 3 URL',
}

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


salt '*' chocolatey.install rs-ssms-extension version="1.5.0" 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.

This package was approved by moderator mwallner on 23 Nov 2017.

Description

Microsoft SQL Server Management Studio extension

Package installation parameters:
CS: 0/1 - install custom scripts
V2016: 0/1 - installs extension in SSMS 2016 folder
V2017: 0/1 - installs extension in SSMS 2017 folder

*if neither V2016 or V2017 is indicated, by default it will install for version 2016

Please install the Management Studio manually prior to this extension!

tools\chocolateyinstall.ps1 
$ErrorActionPreference = 'Stop';

$pp = Get-PackageParameters

$packageName= 'rs-ssms-extension'
$toolsDir   = "$(Split-Path -parent $MyInvocation.MyCommand.Definition)"
$fileLocation = Join-Path $toolsDir 'RS.SSMS.Installer.msi'

$silentArgs = "/q"

if($pp -and $pp.count -gt 0)
{
	if($pp.CS)
		{ $silentArgs += " CS=" + $pp.CS }
		
	if(-not ($pp.V2016 -or $pp.V2017))
		{ $silentArgs += " V2016=1" }
	else
	{
		if($pp.V2016)
			{ $silentArgs += " V2016=" + $pp.V2016 }
		if($pp.V2017)
			{ $silentArgs += " V2017=" + $pp.V2017 }
	}
}
else
{
	$silentArgs += " V2016=1"
}

$packageArgs = @{
  packageName   = $packageName
  unzipLocation = $toolsDir
  fileType      = 'MSI'
  file          = $fileLocation
  silentArgs    = $silentArgs
  validExitCodes= @(0, 3010, 1641)
}

Install-ChocolateyInstallPackage @packageArgs
tools\LICENSE.txt 
From: http://www.apache.org/licenses/LICENSE-2.0

LICENSE

Copyright [2017] [Romanian Software]

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
tools\RS.SSMS.Installer.msi 
md5: 2B77F4050BC4551BAAC062EF8C6D6E57 | sha1: DEB3306F0385C49072D976BAB87ABBE8BD869EA0 | sha256: 1EF27B340EDBDFC1E124517A027ED78BF7B4526F44BB50998298FF0B4ED6B35A | sha512: 024BEEF2B6862F725A14A4744B7ECB9F52FEE4102414F8CE8A86840C2114DC13ABE72464C80BD773334D1696ABA9DD0725ECA5F95D880F24680B1A9FDA3247F1
tools\VERIFICATION.txt 
VERIFICATION

Verification is intended to assist the Chocolatey moderators and community
in verifying that this package's contents are trustworthy.
 
Package can be verified like this:

1. Go to

   http://projects.romaniansoftware.ro/RS.SSMS.Web/Content/Files/RS.Deploy.Web.ChocoInstaller.msi

   to download the installer.

2. You can use one of the following methods to obtain the SHA256 checksum:
   - Use powershell function 'Get-FileHash'
   - Use Chocolatey utility 'checksum.exe'

   checksum: 
1EF27B340EDBDFC1E124517A027ED78BF7B4526F44BB50998298FF0B4ED6B35A

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
RS.SSMS.Extension 1.5.0 544 Tuesday, November 21, 2017 Approved
RS.SSMS.Extension 0.1 383 Thursday, May 11, 2017 Approved
Discussion for the RS.SSMS.Extension Package

Ground Rules:

  • This discussion is only about RS.SSMS.Extension and the RS.SSMS.Extension 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 RS.SSMS.Extension, 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