CodePlexProject Hosting for Open Source Software
maybe i didn't looked deep enough,
but is there a way instead of using a query in the Set-Sqldata command to pass a *.sql file?
I'd like to run some create Procedure - scripts via SQLPSX.
Not directly, but you could work around the issue by assigning the contents of your sql file to a variable as follows:
$file = $(resolve-path test.sql).path
$out = [System.IO.File]::ReadAllText("$file")
get-sqldata -sqlserver "Z002\sql2k8" -dbname pubs -qry $out
Thank you that worked for me.
Maybe a command for this would be an enhancement for next Versions ;-)
Are you sure you want to delete this post? You will not be able to recover it later.
Are you sure you want to delete this thread? You will not be able to recover it later.