I have just installed vs2010 sp1 ultimate, sqlserver 2012 and the latest version of sqlserver data tools. I have opened up a solution from source control and receive a bunch of error like the following when trying the build the database project.
我刚刚安装了vs2010 sp1 ultimate，sqlserver 2012和最新版本的sqlserver数据工具。我从源代码控制中打开了一个解决方案，并在尝试构建数据库项目时收到如下所示的一堆错误。
SQL71566: Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlFilegroup cannot not be set on both the Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlTable and the clustered Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlPrimaryKeyConstraint.
SQL71566：Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlFilegroup不能同时在Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlTable和群集的Microsoft.Data.Tools.Schema.Sql.SchemaModel上设置。 SqlPrimaryKeyConstraint。
Running on Windows 7 professional, 64 bit
在Windows 7专业版，64位上运行
This is working fine for other members of the team and they all seem to have the same setup as me.
这对团队的其他成员来说很好，他们似乎都和我一样。
I have tried uninstalling and reinstalling vs2010 and ssdt
我已经尝试卸载并重新安装vs2010和ssdt
Any ideas anyone?
任何人的想法？
2 个解决方案
#1
2
This seems to be a bug to which MS has not yet delivered a fix:
这似乎是MS尚未提供修复的错误：
http://connect.microsoft.com/VisualStudio/feedback/details/765217/when-compiling-vs2010-database-project-in-vs2012-i-receive-error-sql71566
#2
9
I was receiving this error with the November 2012 SSDT release but only when I moved a project from a 32 bit vista machine to a 64 bit vista machine. I was able to get my project to build by enabling the project setting "Enable extended Transact-SQL verification for common objects.". Enabling this setting in the past has caused other issues so I am not sure if this will surface other problems in this environment.
我在2012年11月的SSDT版本中收到了这个错误，但只有当我将一个项目从32位vista机器移动到64位vista机器时。通过启用项目设置“为常见对象启用扩展的Transact-SQL验证”，我能够构建我的项目。过去启用此设置会导致其他问题，因此我不确定这是否会在此环境中出现其他问题。
#1
2
This seems to be a bug to which MS has not yet delivered a fix:
这似乎是MS尚未提供修复的错误：
http://connect.microsoft.com/VisualStudio/feedback/details/765217/when-compiling-vs2010-database-project-in-vs2012-i-receive-error-sql71566
#2
9
I was receiving this error with the November 2012 SSDT release but only when I moved a project from a 32 bit vista machine to a 64 bit vista machine. I was able to get my project to build by enabling the project setting "Enable extended Transact-SQL verification for common objects.". Enabling this setting in the past has caused other issues so I am not sure if this will surface other problems in this environment.
我在2012年11月的SSDT版本中收到了这个错误，但只有当我将一个项目从32位vista机器移动到64位vista机器时。通过启用项目设置“为常见对象启用扩展的Transact-SQL验证”，我能够构建我的项目。过去启用此设置会导致其他问题，因此我不确定这是否会在此环境中出现其他问题。