I know how to build and deploy my database project using MSBuild, but
for some reason I can't get it translated into a CC build. Here is
the MSBuild execution:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\msbuild.exe /
t:Build;Deploy /
p:DeployToDatabase=true;BuildScriptName=EdAmericaDB.sql;outdir=C:\Work
\SC\Database\edAmericaDB\sql\release
\;TargetDatabase=EdamericaDB;TargetConnectionString="Data
Source=devsql1\dev05;Integrated Security=True;Pooling=False" C:\Work\SC
\Database\edAmericaDB\EdAmericaDB.dbproj
CC just does not seem to like how I am splitting the MSBuild
execution. Here is the syntax that I am trying and it fails in the
validator:
<msbuild>
<executable>C:\WINDOWS\Microsoft.NET\Framework
\v4.0.30319\MSBuild.exe</executable>
<workingDirectory>c:\work\SC\Database\edAmericaDB</
workingDirectory>
<buildArgs>/t:Build;Deploy /
p:DeployToDatabase=true;BuildScriptName=EdAmericaDB.sql;outdir=C:\Work
\SC\Database\edAmericaDB\sql\release
\;TargetDatabase=EdamericaDB;TargetConnectionString="Data
Source=devsql1\dev05;Integrated Security=True;Pooling=False" C:\Work\SC
\Database\edAmericaDB\EdAmericaDB.dbproj</buildArgs>
<timeout>6000</timeout>
<logger>C:\Program Files\CruiseControl.NET\server
\ThoughtWorks.CruiseControl.MsBuild.dll</logger>
</msbuild>
<msbuild>
<Target Name="AfterDropBuild">
<Message Text="Deploy of project database" />
<MSBuild Projects="C:\Work\SC\Database\edAmericaDB
\EdAmericaDB.dbproj" Properties="OutDir=C:\Work\SC\Database\edAmericaDB
\sql\release\;TargetDatabase=EdamericaDB;TargetConnectionString='Data
Source=devsql1\dev05;Integrated
Security=True;Pooling=False';DeployToDatabase=true;" />
</Target>
</msbuild>
Any suggestions or help would be greatly appreciated.