Accepts SQL Connection strings and converts them to and from powershell objects for easy manipulation and use

ConvertFrom-SQLDatabaseConnectionString.ps1

function ConvertFrom-SQLDatabaseConnectionString {
    [OutputType([PSCustomObject])]
    [cmdletbinding()]
    param(
        [Parameter(mandatory, Valuefrompipeline)]
        [string]
        $ConnectionString
    )

    begin {
        $hash = @{}
    }

    process {
        $ConnectionString.Split(";") | % {
            $d = $_.Split("=").Trim()
            $hash.Add($d[0], $d[1])
        }
    }

    end {
        return [PSCustomObject]$hash
    }
}

function ConvertTo-SQLDatabaseConnectionString {
    [OutputType([string])]
    [cmdletbinding()]
    param(
        [Parameter(mandatory, Valuefrompipeline)]
        [PSCustomObject]
        $ConnectionStringObject
    )

    begin {
        $Connstring = ""
    }

    process {
        $ConnectionStringObject | get-member | ? MemberType -ne "method" | % {
            $Connstring += [string]::Format("{0}={1};", $_.name, $ConnectionStringObject."$($_.Name)")
        }
    }

    end {
        return $Connstring
    }
}