Visual Studio 2015 Update 2 和 Sql Server 2016 架构比较 [英] Visual Studio 2015 Update 2 and Sql Server 2016 Schema Compare

问题描述

我最近升级到 Visual Studio 2015 Update 2 并且一切进展顺利，现在当我尝试从数据项目对 Sql Server 2016 数据库进行架构比较时，它显示我需要在数据库中创建所有对象.在此更新之前，这工作正常.

I recently upgraded to Visual Studio 2015 Update 2 and that all went smoothly however, now when I attempt to do a Schema Compare from a data project against a Sql Server 2016 database it shows that i needs to create all objects in the database. This worked fine before this update.

比较初始化时出现以下错误:

I get the following error when the compare initializes:

尝试逆向工程元素时出错类型Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlDatabaseCredential:逆向工程期间的批处理命令失败并显示错误代码:-2146232060 行号:2267 错误消息:无效的列名 compression_delay.列名无效compression_delay.

An error occurred while attempting to reverse engineer elements of type Microsoft.Data.Tools.Schema.Sql.SchemaModel.SqlDatabaseCredential: Batch Command during reverse engineer failed with Error Code: -2146232060 Line Number: 2267 Error Message: Invalid column name compression_delay. Invalid column name compression_delay.

有谁知道是什么导致了这个问题?提前致谢.

Does anyone know what is causing this problem? Thanks in advance.

推荐答案

我不确定是什么导致了这个问题的发生，但我最终分离了我的所有数据库，卸载了 SQL Server 并进行了全新安装.之后，所有脚本和 VS 数据比较都正常工作.

I'm not sure what caused this problem to happen but I ended up detaching all my databases, uninstalling SQL Server and doing a fresh install. After that all scripts and VS data compares worked correctly.

这篇关于Visual Studio 2015 Update 2 和 Sql Server 2016 架构比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！