Vista - Run executable with commandline arguments

I'm new to PowerShell.. I am creating a script to run a set of database
scripts using sqlcmd, but I can't get it to pass the command line arguments
correctly.

I have tried Invoke-Item and using sqlcmd as a command in itself but it
doesn't work.

The script below gives the following sample result:
sqlcmd -S:localhost -dMyDb -E -i:MyScript.sql
Sqlcmd: 'localhost': Unexpected argument. Enter '-?' for help.

Full script below:

$Server = ""
$Database = ""
$User = ""
$Pwd = ""
$TrustedConnection = ""

$args | foreach-object {
$currentArg = $_
switch($currentArg.SubString(0,2))
{
/S {
Write-Host "Server argument found: " $currentArg
$Server = $currentArg.SubString(3)
}
/D {
Write-Host "Database argument found: " $currentArg
$Database = $currentArg.SubString(3)
}
/U {
Write-Host "User argument found: " $currentArg
$User = $currentArg.SubString(3)
}
/P {
Write-Host "Password argument found: " $currentArg
$Pwd = $currentArg.SubString(3)
}
/E {
Write-Host "TruestedConnection argument found: " $currentArg
$TrustedConnection = $currentArg.SubString(3)
}
}
}

Write-Host "Commandline parsed. The following have been set:"
Write-Host "Server: " $Server
Write-Host "Database: " $Database
Write-Host "User: " $User
Write-Host "Trusted Connection: " $TrustedConnection

#Build the command based on the parameters

Get-Content files.txt | foreach {
if($TrustedConnection.Length -gt 0)
{
Write-Host "sqlcmd -S:$Server -d:$Database -E -i:$_"
sqlcmd -S:$Server -d:$Database -E -i:$_
}
else
{
Write-Host "sqlcmd -S:$Server -d:$Database -U:$User -P:$Pwd -i:$_"
sqlcmd -S:$Server -d:$Database -U:$User -P:$Pwd -i:$_
}
}

dircums wrote:
Many different ways to do this... Here's one that seems to work:

sqlcmd `-S localhost `-d pMyDb -E `-i MyScript.sql

PowerShell is trying to interpret the "-" and ":", so I'm escaping them.

Give that a try.

(I used echoargs.exe from PSCX--http://www.codeplex.com/powershellcx/)

Marco

--
Microsoft MVP - Windows PowerShell
http://www.microsoft.com/mvp

PowerGadgets MVP
http://www.powergadgets.com/mvp

Blog:
http://marcoshaw.blogspot.com