I have one database VS2008 project/solution. I'm using cruise control (with SVN, and NAnt) to automate the deployment of the database changes. This works fine so far. I'm able to monitor SVN changes, update the database project folder, and deploy the changes to our database.
I was wondering if it's possible to deploy to multiple database (instead of just one target database)? I would like to have multiple target databases. I get the error that the project file and the target are not in sync. I thought that by using the deploy and target parameters, this would overwrite what's actually in the project for the deployment properties. So while this works: <msbuild> <executable>C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\MSBuild.exe</ executable> <workingDirectory>C:\Test_Folder\Database Related\Public Database Project\Database Project</workingDirectory> <projectFile>DB_Project.dbproj</projectFile> <buildArgs>/target:Deploy / property:TargetDatabase=Test_Public;TargetConnectionString="Data Source=localhost;Initial Catalog=Test_Public;Integrated Security=True;" </buildArgs> <targets>Build</targets> <timeout>900</timeout> <logger>C:\Program Files\CruiseControl.NET\server \ThoughtWorks.CruiseControl.MsBuild.dll</logger> </msbuild> If i try to copy this and have another one (right after) and change the target database; i get the error that the new target database is not in the project file. Is this possible? Any ideas would be greatly appreciated... Keywords: CruiseControl, SVN, Deploy Database, MSBUILD, NAnt
