SQL Server Data Tools and Visual Studio Problem

Question

I just installed vs2010 sp1 ultimate, sqlserver 2012 and latest sqlserver data tools. I opened the solution from the control source and get a bunch of errors, for example, when trying to build a database project.

SQL71566: Microsoft.Data.Tools.Schema.Sqhem.SchemaModel.SqlFilegroup cannot be installed both in Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlTable and in a clustered Microsoft.Data.Tools.Schema.Sql.SchemaModel .SqlPrimaryKeyConstraint.

Works on Windows 7 Professional, 64 bit

This works great for other team members, and they all all seem to have the same setup as me.

I tried uninstalling and reinstalling vs2010 and ssdt

Any ideas anybody?

Answer 1

This seems to be a bug that MS has not yet patched:

http://connect.microsoft.com/VisualStudio/feedback/details/765217/when-compiling-vs2010-database-project-in-vs2012-i-receive-error-sql71566

Answer 2

I got this error with the SSDT release in November 2012, but only when I moved the project from a 32-bit Vista machine to a 64-bit Vista machine. I managed to create my project by including the project option "Enable Transact-SQL Advanced Validation for Regular Objects". Enabling this option in the past caused other problems, so I'm not sure if this will cause other problems in this environment.