SSDT 模式比较锁 SET QUOTED_IDENTIFIER 到 OFF [英] SSDT schema compare lock SET QUOTED_IDENTIFIER to OFF

问题描述

我安装了 Visual Studio 2012，并安装了 SSDT 版本 11.1.20627.0.

I have Visual studio 2012 installed with SSDT version 11.1.20627.0 installed.

一直困扰我的问题之一是我在 SSDT 项目中的所有存储过程，当尝试使用模式比较将其推送到服务器时.SP 的 SET QUOTED_IDENTIFIER 始终切换为 OFF，我找不到改变这种行为的方法.

One of issue keep bugging me is for all my stored procedures in SSDT project, when try to push it to server using schema compare. The SP's SET QUOTED_IDENTIFIER was always switched to OFF and I cannot find a way to change this behavior.

目标数据库是我的本地数据库，它的默认 QUOTED_IDENTIFIER 已更改为 ON(True);

The target database is my local DB and its default QUOTED_IDENTIFIER was changed to ON(True);

在数据库项目属性页中，SET QUOTED_IDENTIFIER"复选框被选中，但整个复选框被禁用.

In Database project property page, The "SET QUOTED_IDENTIFIER" checkbox was checked but the whole checkbox is disabled.

我尝试更改一些架构比较选项，例如忽略表选项"，结果相同:它总是给我一些如下更新脚本:

I tried to change some Schema compare options such as "Ignore table options" and the result are same: it always give me some update script like below:

GO
USE [$(DatabaseName)];


GO
PRINT N'Creating [dbo].[myspname]...';


GO
SET ANSI_NULLS ON;

SET QUOTED_IDENTIFIER OFF;


GO

任何提示都适用

推荐答案

终于搞清楚了.它是由旧版本的SSDT引起的.安装了标有 SSDT_11.0.50730.0 的 SSDT 现在似乎可以工作了.

Finally figure it out. it is caused by old version of SSDT. Installed the SSDT labeled SSDT_11.0.50730.0 seems working now.

我不得不抱怨 SSDT 奇怪的版本规则:它看起来

I have to complain on SSDT's strange versioning rule: it looks

• 11.xxxxx 适用于 Visual Studio 2012

• 11.xxxxx is for Visual Studio 2012

12.xxxxx 适用于 Visual Studio 2013

12.xxxxx is for Visual Studio 2013

14.xxxxx 适用于 Visual Studio 2015

14.xxxxx is for Visual Studio 2015

并且第二个版本号在安装媒体中始终为 0，但如果您安装了它并在 Visual Studio 的关于"窗口中查看它.它将更改为 1.

and the second version number is always 0 in installation media, but if you installed it and view it in Visual studio's About window. it will changes to 1.

这真的很令人困惑，因为它会让您相信 11.1.20627.0 版比 11.0.50730.0 版更新.这不是真的.

That is really confusing cause it will make you believe Version 11.1.20627.0 is newer than version 11.0.50730.0. which is not true.

这篇关于SSDT 模式比较锁 SET QUOTED_IDENTIFIER 到 OFF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！