How to ignore data loss warning while schema comparison?
In 2015 the sequence is: Create Compare, click on gear icon, general tab, unclick "Block on data loss". I have to set this each time I create a new comparisons, I have been unable to find a way to set a default that sticks other than saving the comparison.
I had this same problem, and unchecking the "Block Incremental Deployment if data loss might occur" didn't fix the issue. I still got lost of errors regarding column size changes that I couldn't work around. I also had to uncheck the "Verify deployment" checkbox, the last item in the lower section, as well.
If deploying the dacpac using sqlpackage.exe command-line utility(used for automating build/deployments like in DevOps), then we need to pass the argument: /p:BlockOnPossibleDataLoss=False
More info here -> https://docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage?view=sql-server-ver15