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.fullPathTest-Path$fp.fullPath
}
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