Octopus - SQL Deploy DACPAC Community Contributed Step

1
votes

I am using the SQL Deploy DACPAC community contributed step to deploy my dacpac to the server within Octopus.

It has been setup correctly and has been working fine until the below situation occurs.

I have a situation where I am dropping columns but the deploy keeps failing due to rows being detected. I am attempting to use /p:BlockOnPossibleDataLoss=false as an "Additional deployment contributor arguments" but it seems to be ignored.

Can anyone guide me to what is wrong?

1
octopus-deploydacpac

1 Answers

0
votes

The publish properties should have DropObjectsNotInSource, try to set it to True. You might want to fine tune it, to avoid dropping users, permissions, etc.