PSCI

1.1.0

baseModules/PPoShSqlTools/0.1.5/Private/Get-CurrentSqlCmdPath.ps1

function Get-CurrentSqlCmdPath {
    <#
    .SYNOPSIS
    Returns sqlcmd.exe folder path

    .DESCRIPTION
    Search for sqlcmd bin path in system registry. First found version will be returned.

    .EXAMPLE
    Get-CurrentSqlCmdPath
    #> 

    [CmdletBinding()] 
    [OutputType([string])]
    param()

    $sqlServerVersions = @('150', '140', '130', '120', '110', '100', '90')
    foreach ($version in $sqlServerVersions) {
        $regKey = "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$version\Tools\ClientSetup"
        if (Test-Path -LiteralPath $regKey) {
            $path = (Get-ItemProperty -Path $regKey).Path
            if ($path) {
                $path = Join-Path -Path $path -ChildPath 'sqlcmd.exe'
                if (Test-Path -LiteralPath $path) {
                    return $path
                }
            }
            $path = (Get-ItemProperty -Path $regKey).ODBCToolsPath
            if ($path) {
                $path = Join-Path -Path $path -ChildPath 'sqlcmd.exe'
                if (Test-Path -LiteralPath $path) {
                    return $path
                }
            }
        }
        # registry not found - try directory instead
        $path = "$($env:ProgramFiles)\Microsoft SQL Server\$version\Tools\Binn\sqlcmd.exe"
        if (Test-Path -LiteralPath $path) {
            return $path
        }
    }

    return $null
}