I'm having issues trying to get teamcity to deploy my database projects in vs 2010. I have a solution that has 3 database projects in it, and they each have Deploy options set up to only create the .sql file. Now if I "Deploy Solution" in Visual Studio 2010 I get a ProjectName.sql file created. I've tried to setup this solution in TeamCity but I can't get it to create the .sql file. I can get it to successfully "Build" the project, but just building doesn't create the script. I am using the Visual Studio (sln) build runner, and I've tried setting the target to "Deploy" but I get an error about an invalid target. The reason I tried to use the "Deploy" target was based on the fact I saw a MSBuild guide on MSDN that used /t:Deploy. I've also tried to switch to the MSBuild runner, point the solution file to the database project file and use /t:Deploy, but I get assembly not found errors like that.
Does anyone have any advice or a guide on how to get TeamCity to deploy a database project? I've gotten TeamCity to work with my VS website, but I just can't get the database projects to work. thanks