data-tier-applicationsql serversql-server-2012ssdtvisual studio 2012
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.
I am using Visual Studio 2010 and SQL 2008 database projects, but the idea remains the same. In your solution go to the project and do the following steps:
If you'd like to NOT deploy any of the project default settings, you should do the following steps:
That should help you change/remove the current project settings that you're now deploying.
Look at the references in your database solution. You will probably see them there. You can use the SQLPackage Script action to see the variables actually included in your dacpac.
Best Answer
Have you tried executing sqlpackage.exe with
/p:BlockOnPossibleDataLoss=falsein the command line?I just used SQLPackage.exe to create a .dacpac file of my test database, then I pubished it with the
/p:BlockOnPossibleDataLoss=falseoption, and it overwrote my database.