You may receive error messages when you build a team project that contains a database unit test in Visual Studio 2005 Team Edition for Database Professionals

Consider the following scenario. You have a database project in Microsoft Visual Studio 2005 Team Edition for Database Professionals. You add a data generation plan to the database project. You add a test project with a database unit test to the database project solution. You add the database solution to a team project on Microsoft Visual Studio 2005 Team Foundation Server. You create a team build for the team project. You execute the team build. In this scenario, you may receive the following error messages during the build process:

To work around this problem, follow these steps:

1. In Team Explorer, expand Team Builds, right-click the build type that you want to modify, and then click View Team Build Type.
2. In the Project tag, add the following tags:

   <ItemGroup>
           <TestProject1TeamBuildConfigFile Include="$(BuildDirectoryPath)\<BuildTypeName>\Sources\<ProjectName>\TeamBuild.app.config"/>
       </ItemGroup>
   
   <Target Name="CopyFiles">
           <Copy
               SourceFiles="@(TestProject1TeamBuildConfigFile)"
               DestinationFiles="@(TestProject1TeamBuildConfigFile->'%(BuildDirectoryPath)%\<BuildTypeName>\Binaries\Realease\<TeamProjectName>.dll.config')"
           />
   </Target>

   Note <BuildTypeName> represents the name of the build type. <ProjectName> represents the name of the project. <TeamProjectName> represents the name of the team project.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

For more information about database unit tests, visit the following Microsoft Developer Network (MSDN) Web site: