Building database projects using TFS 2010 Beta 1

Question

If you are using TFS 2010 Beta 1 and attempt to build a database project created using the GDR you will get the following error:

C:\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\TeamData\Microsoft.Data.Schema.Common.targets (30): The expression "$(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\VSTSDB@VSTSDBDirectory)" cannot be evaluated.

Fix the problem by editing the file "Microsoft.Data.Schema.Common.targets" in the folder "...\Program Files\MSBuild\Microsoft\VisualStudio\v9.0\TeamData"

Replace:

<VSTSDBDirectory Condition="'$(VSTSDBDirectory)' == ''">$(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\VSTSDB@VSTSDBDirectory)</VSTSDBDirectory>

With

<VSTSDBDirectory Condition="'$(VSTSDBDirectory)' == ''">$(registry:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VisualStudio\9.0\VSTSDB@VSTSDBDirectory)</VSTSDBDirectory>

---

Duke Kamstra - Program Manager - VSTS Database Edition (Data Dude, DBPro)