We actually have a Windows Server 2008 R2 with Team Foundation Server 2010 installed, which has a projectcollection configured. A databaseproject was migrated from Visual Studio Premium 2010 to Visual Studio Premium 2012 and checked in to TFS2010.
On another Windows Server 2008 R2, Team Foundation Server 2010 is as TFS Build Server with Build Agents installed [TFS2010 Server with projectcollection and TFS Build Server 2010 works fine together].
After migration of databaseproject from Visual Studio Premium 2010 to Visual Studio Premium 2012, TFS Build and Deployment does not work, because on TFS2010 Build server, .deploymanifest file was used. But now for dbproject in VS2012, there are fewer files with .dacpac files.
I was reading a lot about compatibility and there is different information about executing db project build and deployment form VS2012 on a VS2010 TFS build server.
If I deinstall TFS2010 build server and installed TFS2013, at this point to select the project collection on the TFS2010, there will be shown an incompatibility error.
Is there an solution where we can build and deploy a VS2012 db project checked in TFS2010 from VS2012 on a TFS2010 or TFS2013 build server?