Deploy database project (.dbproj) using powershell

Question

I want to deploy a database project "database.dbproj" (for example) using powershell. So far, I tried to deploy project using following methods,

$msbuild = 'C:\Windows\Microsoft.NET\Framework\v4.0.30319\MSBuild.exe'

$option1 = @(' /t:reBuild,deploy /p:TargetConnectionString="Data Source=(local)\SQL2008R2;Integrated Security=True;Pooling=False;" /p:TargetDatabase=test "C:\TEMP\SVN\6000\Database\Database.dbproj"')

& $msbuild $option1

And

$test1 = @(' /target:Build,deploy','C:\TEMP\SVN\6000\Database\Database.dbproj','/property:TargetConnectionString="Data Source=(local)\SQL2008R2;Integrated Security=True;Pooling=False;"','/property:TargetDatabase=test')

& $msbuild $test1

and

$test2 = $msbuild +"" + $option1

Invoke-Expression $test2

But in all cases it doesn't do anything. I mean if I debug the code then I can see that this pointer reaches to this command and then simply moves to next line of command without doing anything. I have similar Batch script, and it works just fine. So I am sure that it is some noob mistake that is causing this issue. What is wrong I am doing here ?

Thanks, Jack

Musaab Al-Okaidi · Accepted Answer · 2013-02-11 15:59:51Z

6

Try the following:

Start-Process -FilePath "C:\Windows\Microsoft.NET\Framework\v4.0.30319\MSBuild.exe" -ArgumentList "/t:reBuild,deploy /p:TargetConnectionString=`"Data Source=(local)\SQL2008R2;Integrated Security=True;Pooling=False;`" /p:TargetDatabase=test `"C:\TEMP\SVN\6000\Database\Database.dbproj`""

answered Feb 11, 2013 at 15:59

Musaab Al-Okaidi

3,79425 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Deploy database project (.dbproj) using powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related