I have a Visual Studio 2010 solution containing 2 database projects, the primary project is a SQL Server 2005 database project, the secondary project is a 2008 database project. The main 2005 project is deployed when you deploy the solution, however I would like this to also then deploy the 2008 project.
Currently I have to do the second project by hand and as a result sometimes forget to deploy it.
I reckon this must be achievable with a bit of MSBuild but could do with some pointers!!
Sam : )
In Visual Studio go to
Build > Configuration Manager
. There should be aDeploy
option to enable/disable deployment of each database project.