如何修复发现的不兼容SQL Server版本? [英] How do I fix incompatible SQL Server version found?
问题描述
我正在使用刚刚安装了SQL Server 2014 Express的VS 13，创建了一个新数据库，当我去添加新表(在VS内)时，出现以下错误:
I'm using VS 13 just installed SQL Server 2014 Express, created a new database and when I go to add a new table (inside VS) I get the following error:
找到不兼容的sql server版本
incompatible sql server version found
我该如何解决?我是否应该找到VS所需的版本(如果需要，怎么办?)并将其降级到该所需版本，或者我可以使用SQL Server 2014 Express解决该问题?
How do I fix this? Should I find the version required by the VS (if so, how?) and I downgrade to that required version or can I workaround it with SQL Server 2014 Express?
推荐答案
-
检查项目属性"的项目设置"选项卡中的目标平台:"下拉菜单.如果未选择"SQL Server 2014"，则选择它.如果"SQL Server 2014"甚至不在列表中，则需要执行下一部分(#2).
Check the "Target platform:" drop-down in the "Project Settings" tab of Project Properties. If "SQL Server 2014" is not selected, select it. If "SQL Server 2014" is not even in the list, you need to do the next part (#2).
确保您具有最新版本的SQL Server数据工具(SSDT). VS 2013社区版(如果不是其他版本的话)附带的版本并不完全有效；-).
Make sure that you have the latest version of SQL Server Data Tools (SSDT). VS 2013 Community Edition (if not also other editions) shipped with a version that didn't exactly work ;-).
您应该可以通过以下操作获得此信息:
You should be able to get this by doing the following:
- 打开Visual Studio
- 转到工具"菜单
- 选择扩展和更新..."
- 展开更新"(左侧导航栏)
- 转到产品更新"
- 选择"SQL Server数据工具"的条目(或名称相似的任何条目)
- 点击该条目中的更新"按钮
- 它将下载名为"SSDTSetup.exe"的文件到您的计算机
- 运行"SSDTSetup.exe"，它将下载并安装更新的版本(截至目前，当前版本为12.0.41025)
- 安装完成后，关闭并重新打开Visual Studio
- Open Visual Studio
- Go to the TOOLS menu
- Select "Extensions and Updates..."
- Expand "Updates" (left nav)
- Go to "Product Updates"
- Select the entry for "SQL Server Data Tools" (or whatever has a similar name)
- Click the "Update" button within that entry
- It will download a file to your computer called "SSDTSetup.exe"
- Run "SSDTSetup.exe" and it will download and install the updated version (as of right now the current version is 12.0.41025)
- Once it is done installing, close and re-open Visual Studio
或者您可以从 http://msdn.microsoft.com/下载zh-cn/data/tools.aspx (只需确保获取与您拥有的Visual Studio版本相对应的版本)即可.
Or you can download it from http://msdn.microsoft.com/en-us/data/tools.aspx (just be sure to get the version that corresponds to the version of Visual Studio that you have).
在两个地方都有一个允许不兼容的平台"复选框:
There is a check-box for "Allow incompatible platform" in two places:
- 项目属性"的调试"选项卡.单击底部的高级..."按钮.它将位于可滚动列表的顶部. 从构建"菜单转到发布项目"时，发布数据库"弹出窗口中的
- 高级"按钮(在右侧).它将位于可滚动列表的顶部.
- Debug tab of Project Properties. Click on the "Advanced..." button at the bottom. It will be at the top of the scrollable list.
- Advanced button (on the right) in the "Publish Database" popup when you go to Publish the project from the Build menu. It will be at the top of the scrollable list.
这篇关于如何修复发现的不兼容SQL Server版本?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
