为什么 SSDT 架构比较在 DefaultExpressionScript 中显示差异? [英] Why is SSDT Schema Compare showing difference in DefaultExpressionScript?

问题描述

在使用 SSDT 将数据库实例与 VS2010 中的数据库项目进行比较时，它显示了其中一个存储过程的差异.Store Procedure DDL 脚本完全相同，但是当我展开 Store Procedure 下的 Properties 文件夹时，它显示了 DefaultExpressionScript 的不同之处.

While comparing Database instance to a Database project in VS2010 using SSDT, it shows a difference in one of the Stored Procedures. The Store Procedure DDL script is exactly the same but when I expanded the Properties folder under the Store Procedure it show a difference in the DefaultExpressionScript.

源 SP 在 DefaultExpresionScript 中显示了这一点:

The source SP shows this in the DefaultExpresionScript:

DefaultExpressionScript = at

虽然目标 SP 有这个:

While the destination SP has this:

DefaultExpressionScript = -1

我不知道在哪里可以更改它在我的数据库项目中没有名为 DefaultExpressionScript 的对象.我应该在哪里解决这个问题?

I don't see where I can change this there is no such object called DefaultExpressionScript in my database project. where should I fix this?

推荐答案

这个错误仍然存​​在于 VS 2015 Update 3 with SSDT 14.0.61021.0.但是，只需在 SSMS 中使用 ALTER ... 编写存储过程脚本并运行该查询(不应更改任何内容)即可为我修复它.之后的模式比较不再显示差异.

This bug is still present in VS 2015 Update 3 with SSDT 14.0.61021.0. However, just scripting the stored procedure with ALTER ... in SSMS and running that query (which shouldn't change anything) fixed it for me. The schema comparison didn't show differences anymore afterwards.

这篇关于为什么 SSDT 架构比较在 DefaultExpressionScript 中显示差异?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！