sqlpackage.exe ignoring BlockOnPossibleDataLoss?

14 votes

3 answers

20449 views

sql-server sql-server-2012 ssdt visual-studio-2012 data-tier-application

                          I have a dacpac that has set the BlockOnPossibleDataLoss set to false, however the deployment is blocked when I run it with sqlpackage.exe, telling me "The column [a] is being dropped, data loss could occur."

However when I use the exact same deployment profile and publish from Visual Studio 2012 it goes through.

Asked by nojetlag (2927 rep)

Nov 8, 2013, 04:42 PM
Last activity: Apr 3, 2019, 10:50 AM

sqlpackage.exe ignoring BlockOnPossibleDataLoss?

Related Questions