安装 CLR 对象后，Sql 架构比较不会更新“检测到源架构漂移" [英] Sql Schema Compare will not update after CLR object installed 'Source schema drift detected'

问题描述

安装自定义 CLR 对象后，Sql Server Developer Tools (SSDT) VS2012 将不允许更新.错误是检测到源架构漂移.按比较刷新.刷新后发生同样的事情.

After installing a custom CLR object Sql Server Developer Tools (SSDT) VS2012 will not allow an update. The error is "Source schema drift detected. Press Compare to refresh. After refresh same thing happens.

尝试过在设置中，我将对象设置为仅存储过程.设置 -> 常规 -> 阻止可能的数据丢失 -> 尝试打开和关闭.

Tried In settings, I set the object to just Stored Procedures. Settings ->General -> Block on possible data loss -> tried both on and off.

推荐答案

这种循环也可能是由于引用的 SSDT 项目无法构建造成的.引用的项目可能丢失、卸载或存在阻止比较完成的错误.

This sort of loop can also be caused by a referenced SSDT project failing to build. The referenced project may be missing, unloaded, or have an error which prevents the compare from completing.

这篇关于安装 CLR 对象后，Sql 架构比较不会更新“检测到源架构漂移"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！