Semaphore Media and Development

I found a great article on how to configure auto deploy VS database project after build using TFS 2010.

http://www.codewrecks.com/blog/index.php/2010/01/04/deploy-a-database-project-with-tfs-build-2010/

One more note: If you want to manually execute the deployment script generated by MSBuild using SQL Mgmt Studio, make sure to set it to SQL Command Mode first or else the :setvar line will error out. To set the mode, goto Query->SQLCMD mode in SQL Mgmt Studio’s menu.