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

T-SQL Flex

0.0.10

Package test results are passing.

This package was approved by moderator purity on 2/10/2015.

SSMS add-in for scripting and Excel export.

To install T-SQL Flex, run the following command from the command line or from PowerShell:

C:\> choco install tsqlflex

To upgrade T-SQL Flex, run the following command from the command line or from PowerShell:

C:\> choco upgrade tsqlflex

Files

Hide
  • tools\chocolateyInstall.ps1 Show
    $packageName = "T-SQL Flex";
    $url = "https://github.com/nycdotnet/TSqlFlex/releases/download/0.0.10-alpha/TSqlFlex-v0.0.10-alpha.zip";
    $installLocation = "$env:ProgramData\T-SQL Flex";
    
    try {
      Install-ChocolateyZipPackage "$packageName" "$url" "$installLocation"
    } catch {
    	Write-ChocolateyFailure "$packageName" "$($_.Exception.Message);"
    	throw;
    }
    
    function Create-RegistryKeyIfNotExists($parentKey, $testKey) {
      if ((test-path "$parentKey\$testKey") -eq $false) {
        New-Item -Path "$parentKey" -Name "$testKey" | Out-Null
      }
      if ((test-path "$parentKey\$testKey") -eq $true) {
    	return "$parentKey\$testKey";
      }
      throw "unable to create or confirm existence of '$parentKey\$testKey'";
    }
    
    # thanks: http://stackoverflow.com/questions/5648931/test-if-registry-value-exists
    function Test-RegistryValue($regkey, $name) {
        $exists = Get-ItemProperty -Path "$regkey" -Name "$name" -ErrorAction SilentlyContinue
        If (($exists -ne $null) -and ($exists.Length -ne 0)) {
            Return $true
        }
        Return $false
    }
    
    function Get-RegistrySoftwareRootKey() {
        if (Get-ProcessorBits -eq 64)  {
    	    Write-Debug "64-bit processor detected.";
            Return "HKLM:\Software\Wow6432Node";
        }
    	Write-Debug "32-bit processor detected.";
    	Return "HKLM:\Software";
    }
    
    try {
    	$root = Get-RegistrySoftwareRootKey;
    	$createdKey = $root;
        $addKeys = "Red Gate\SIPFramework\Plugins";
    	$addKeys.Split("\") | % { $createdKey = Create-RegistryKeyIfNotExists $createdKey $_ }
    	
    	if ((Test-RegistryValue $createdKey "TSQLFlex") -eq $false) {
    		New-ItemProperty -Name "TSQLFlex" -Path $createdKey -Value "$installLocation\TSqlFlex.dll" | Out-Null
    	}
    
    } catch {
    	Write-ChocolateyFailure "$packageName" "$($_.Exception.Message);"
    	throw;
    }
    
    Write-ChocolateySuccess "$packageName"
  • tools\chocolateyUninstall.ps1 Show
    $packageName = "T-SQL Flex";
    $installLocation = "$env:ProgramData\T-SQL Flex";
    
    function Remove-ItemIfExists($itemName) {
    	if ((Test-Path $itemName) -eq $true) {
    	    Remove-Item $itemName;
    	}
    }
    
    # thanks: http://stackoverflow.com/questions/5648931/test-if-registry-value-exists
    function Test-RegistryValue($regkey, $name) {
        $exists = Get-ItemProperty -Path "$regkey" -Name "$name" -ErrorAction SilentlyContinue
        If (($exists -ne $null) -and ($exists.Length -ne 0)) {
            Return $true
        }
        Return $false
    }
    
    function Get-RegistrySoftwareRootKey() {
        if (Get-ProcessorBits -eq 64)  {
            Return "HKLM:\Software\Wow6432Node";
        }
    	Return "HKLM:\Software";
    }
    
    try {
    	Remove-ItemIfExists "$installLocation\RedGate.SIPFrameworkShared.dll";
    	Remove-ItemIfExists "$installLocation\TSqlFlex.Core.dll";
    	Remove-ItemIfExists "$installLocation\TSqlFlex.dll";
    	Remove-ItemIfExists "$installLocation\InstallationInstructions.txt";
    	Remove-ItemIfExists "$installLocation\License.txt";
    	Remove-ItemIfExists "$installLocation\README.txt";
    	
    	$root = Get-RegistrySoftwareRootKey;
    	$pluginsPath = "$root\Red Gate\SIPFramework\Plugins";
    	if ((Test-RegistryValue $pluginsPath "TSQLFlex") -eq $true) {
    		Remove-ItemProperty -Name "TSQLFlex" -Path $pluginsPath | Out-Null
    	}
    	
    } catch {
        Write-ChocolateyFailure $packageName $($_.Exception.Message);
    	throw;
    }
    
    try {
      Remove-ItemIfExists "$installLocation";
    } catch {
      # Don't sweat it.
    }
    
    Write-ChocolateySuccess "$packageName uninstall complete.";

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)

  • Steve Ognibene

Copyright

2015

Tags

Release Notes

  • Implemented drag and drop of database objects from object explorer.

    • Fix for launching Excel exported files when there is a space in the profile path name.

    • Fix for scripting a field name that includes spaces without bracketizing it.

Version History

Version Downloads Last updated Status
T-SQL Flex 0.2.1-beta 420 Friday, July 14, 2017 exempted
T-SQL Flex 0.2.0-beta 490 Saturday, September 24, 2016 exempted
T-SQL Flex 0.1.0-beta 781 Friday, May 8, 2015 exempted
T-SQL Flex 0.0.11-alpha 288 Wednesday, January 28, 2015 exempted

Discussion for the T-SQL Flex Package

Ground rules:

  • This discussion is only about T-SQL Flex and the T-SQL Flex 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 T-SQL Flex, 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