DAC Publish Profile
DAC Publish Profiles are easy to create using Visual Studio. In fact you have probably already created one without even realising.
To create a DAC Publish Profile you simply Publish from within Visual Studio. Clicking the Save Profile button in the Publish screen saves your DAC Publish Profile into your Visual Studio project for later re-use.
Below is our step-by-step to creating your first DAC Publish Profile. However, for those familiar with the process, what you need is two DAC Publish Profiles, one for your CI pipeline and the other for upgrade deployments to your production databases. These are two very different requirements.
In the CI scenario, you simply want to drop and re-create the database as you really do not want remnants of your old deployment interferring with your build, deploy and automated test cycle. Our recommended settings
When upgrading production databases, you really need to take advantage of the fine grain control that DAC Publish Profiles provide.
