Interoperability: QuoteName | Get-Path

[petervandivier]

Objects that get a quoted name from the DB may pass the quoted name onto downstream references. Regex -replace "[\[\]]" use may be required for successful parsing

$objs = (
    "object.with.[Quote Name Required]",
    "object.with.[Quote Name Required 2]"
) | ForEach-Object {
    $d = $_.Split(".")[0]
    $s = $_.Split(".")[1]
    $o = $_.Split(".")[2]

    Get-SqlObject -server "localhost" -database $d -schema $s -object $o
}

$objs | ForEach-Object {
    $fp = Get-SqlObjFilePath `
        -project default `
        -Database $_.database `
        -schema $_.schema `
        -name ($_.name -replace "[\[\]]")`
        -type $_.base_type 
    
    $fp.fullPath
    Test-Path $fp.fullPath
}