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.

Reply via email to