I have VS 2008 solutions that include a number of projects, including a couple of class libraries, a web application, a Windows service, and a SQL 2008 database project. The build server currently has CruiseControl.NET version 1.5.0.6237, a subversion command line client and installed .NET Framework 3.5 SP1 (Windows Server 2008 R2, without Visual Studio). I managed to configure ccnet to get the latest version from the svn repository, build the solution using the MSBuild task, and deploy the web application using robocopy. Now I am struggling to make ccnet deploy the database script, and I also need the Windows service to be deployed and run on the build / dev server. The final error is that the assembly Microsoft.Data.Schema.Tasks is missing on the build server (I had to add Microsoft.Data.Schema.Common.targets and Microsoft.Data.Schema.SqlTasks.targets files to solve and modify the database project file to get this far).
What would be the best CI / deployment approach in my scenario? Do I use the right tools for the job, or should I use something other than ccnet? Do I need to install anything else on the build / dev server to make my life easier?
Please be very specific as I am new to CruiseControl.NET and MSBuild.
source
share