Publish a Database project Through CI action

Continua CI Discussion
1


Hi,

I have  a solution , having 2 web application and a Dabase Project.

I'am able to build my 2 web application using MSBuild action. and by copy action iam able to copy the output to my dirtual dir.

BUT -  How can i publish my DB project. MSbuild is not helpful to publish it to my SQL server.?


Thx in advance

2

Hi,

Are you looking to build, package and deploy both your web applications and your database project all in the same MSBuild?

You can definitely build your database project with MSBuild. We have a tutorial on our wiki that discusses deploying your web applications however at this stage it does not discuss database projects.

Have a look at the following page for more information on deploying your database using MSBuild

http://msdn.microsoft.com/en-us/lib...s.80).aspx

3



Done

Using These Property in MSbuild action:

Configuration=Production
Platform=AnyCPU
SqlPublishProfilePath=$Workspace$\MySourceCode\NextGen DB\NextGen DB\Production.publish.xml

and 

targets : Build;Publish