How to bind the -v parameter of sqlcmd from a PowerShell

Question

The following code, setting the -v parameter directly is working

$sqlcmd = @(Resolve-Path "$env:ProgramFilesMicrosoft SQL Server*ToolsinnSQLCMD.EXE")[0]

$path1 = 'D:somescript.sql'

& $sqlcmd -b -S NB-BKSQLEXPRESS -d BK_Prod -U sa -P mypassword -l 180 -i $path1 -v Mandant=1 SAPMandant="009" SAPEinrichtung="0001" 

But I need a way to set these values from a PowerShell variable.

I tried:

$sqlcmd = @(Resolve-Path "$env:ProgramFilesMicrosoft SQL Server*ToolsinnSQLCMD.EXE")[0]

$path1 = 'D:somescript.sql'

$sqlcmdparameters = 'Mandant=1 SAPMandant="009" SAPEinrichtung="0001" '
& $sqlcmd -b -S NB-BKSQLEXPRESS -d BK_Prod -U sa -P mypassword -l 180 -i $path1 -v $sqlcmdparameters

I found this on SO, but it didn't help me.

Answer 1

I found the following solution for PowerShell V2

$sqlcmd = @(Resolve-Path "$env:ProgramFilesMicrosoft SQL Server*ToolsinnSQLCMD.EXE")[0]
$path1 = 'D:somescript.sql'
$cmdparameters = @(
    'Mandant=1',
    'SAPMandant="009"'
)

& $sqlcmd -b -S NB-BKSQLEXPRESS -d BK_Prod -U sa -P mypassword -l 180 -i $path1 -v $cmdparameters