Team Build Deploy and Database

Question

We've got Team System deploying our Visual Studio projects for everything except Database projects. We got it working on SQL 2000 but cannot seem to make it happen with SQL 2008. The current build error is:

C:\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets(120,5): error MSB4018: The "SqlDeployTask" task failed unexpectedly.

C:\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets(120,5): error MSB4018: System.InvalidOperationException: Nullable object must have a value.

C:\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets(120,5): error MSB4018: at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)

C:\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets(120,5): error MSB4018: at Microsoft.Data.Schema.Tasks.DBDeployTask.Execute()

C:\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\TeamData\Microsoft.Data.Schema.SqlTasks.targets(120,5): error MSB4018: at Microsoft.Build.BuildEngine.TaskEngine.ExecuteInstantiatedTask(EngineProxy engineProxy, ItemBucket bucket, TaskExecutionMode howToExecuteTask, ITask task, Boolean& taskResult)

Ideas on what this could be or help troubleshooting would be great.

Thanks, Chris.

Answer 1

Did you install the GDR release on the Team Build server?

Right now you have to install the GDR release on the build server in order to get it to work, otherwise you are missing binaries other files and settings.

---

GertD @ www.DBProj.com

Answer 2

We had. Just to be safe I upgraded it to Microsoft Visual Studio Team Sytem 2008 Database Edition GDR 9.1.40413.000 and tried the build again. Same error.

Answer 3

Chris,

Can you share how you are calling the deploy target in your TeamBuild project?  You can contact me through http://blogs.msdn.com/bahill/contact.aspx and I will share an example of a TeamBuild project that builds/deploys a database project. 

Thanks,

---

Barclay Hill Program Manager VSTS: DB Team (DataDude, DBPro, Database Edition) Please mark the responses as answer if it resolves your question.

Answer 4

I submitted info through that link.

Thanks!

Answer 5

I got some help from Barclay and it is now working! Here is what we did. We took out the bold Deploy text below

<SolutionToBuild Include="$(BuildProjectFolderPath)/../Database/MyTest.dbproj">

        <Targets>Build;Deploy</Targets>

        <Properties></Properties>
</SolutionToBuild>

and added the following AfterDropBuild target

<Target Name="AfterDropBuild">
    <MSBuild Projects="$(SolutionRoot)\MyTest.dbproj" Properties="Configuration=DEBUG;OutDir=$(DropLocation)\$(BuildNumber)\Default\" Targets="Deploy"/>
</Target>

it all just succesfully completed after that. The build error could use some help but other than that this is very cool. Thanks!