Readyroll : Getting Error While Build Using VSTS : Drift Analysis: These Changes Will NOT Be Applied Because DriftOptionBlockDataLoss=True

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): Error : Drift analysis: T

Solution 1:

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.