Pass multiple parameters to sqlcmd from powershell
Due to some nasty bugs in invoke-sqlcmd wrapper in powershell we must use the following workaround to be able to pass multiple parameters/variables to sqlcmd.exe from powershell $parameterizedCmd = 'sqlcmd -b -E -I -S . -d master -i "script.sql"' + ' -v Parameter1="' +$PsParameter1+ '"' + ' -v Parameter2="' +$PsParameter2+ '"' write-verbose $parameterizedCmd # invoke-expression and invoke-sqlcmd are insanely bugged # workaround by executing via cmd /c instead & cmd /c $parameterizedCmd