Readyroll:使用VSTS进行构建时出错:漂移分析:由于DriftOptionBlockDataLoss = True，因此不会应用这些更改 [英] Readyroll : Getting Error While Build using VSTS : Drift analysis: These changes will NOT be applied because DriftOptionBlockDataLoss=True

问题描述

有些脚本是在不使用readyroll脚本的情况下手动迁移的.现在，任何向dev分支的新推送都会失败，并显示以下错误:

Some of the scripts were migrate manually without using readyroll script. Now any new push to dev branch fails with following error :

DB \ DB.sqlproj(0,0):错误:漂移分析:由于DriftOptionBlockDataLoss = True(有关详细信息，请参见'obj \ Release \ DB_ReSync.sql')，将不会应用这些更改.已检测到可能导致以下表对象丢失数据的更改:dbo.Info.

DB\DB.sqlproj(0,0): Error : Drift analysis: These changes will NOT be applied because DriftOptionBlockDataLoss=True (see 'obj\Release\DB_ReSync.sql' for details). Changes have been detected that could result in data loss for the following table object(s): dbo.Info.

进程"msbuild.exe"以代码"1"退出.

Process 'msbuild.exe' exited with code '1'.

Same在本地运行正常，但在VSTS中创建的构建失败. 成功构建需要做什么?

Same works fine on local but fails in the build created in VSTS. What needs to be done for successful build ?

推荐答案

我使用的是ReadyRoll Core，而不是Pro版本，因为此功能是VSTS扩展的Pro版本的一部分.请参阅与ReadyRoll有关的Red Gate文档和差异报告和差异正确脚本(第4节)，在构建管道中建立了此参数DriftOptionBlockDataLoss和其他相关参数DriftOptionDropMissingObjects.

I am using ReadyRoll Core and not the Pro edition as this functionality is part of the Pro edition of the VSTS extension. Please see the Red Gate documentation pertaining to ReadyRoll and the Diff Report and diff correct script (Section 4), where this param DriftOptionBlockDataLoss and other related params DriftOptionDropMissingObjects are established in the build pipeline.

这篇关于Readyroll:使用VSTS进行构建时出错:漂移分析:由于DriftOptionBlockDataLoss = True，因此不会应用这些更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！