Upgrade Data-Tier Application: Block on downgrade

Question

I'm currently investigating moving over our home-grown deployment scripts to SSDT and DACPACs and have a couple of questions. Consider the following scenario:

• Database deployed version is 1.0.5
• DACPAC version is 1.0.3

When I do an upgrade of the DACPAC either via sqlpackage.exe or SSMS this will just downgrade the database to the 1.0.3 version as it detects the changes. What I would like to see is that the upgrade mechanism blocks because the registered (deployed) version is higher than the package. Is this something that is possible or should the deployment be wrapped in a Powershell script? (not really desirable)

Answer 1

Hi Sander,
 
Thank you for your question. 
I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 
Thank you for your understanding and support.

---

Maggie Luo
TechNet Community Support

Answer 2

Sorry, we do not have anything at this point that blocks based on the version of the DACPAC/registered DAC.