0

Using a DACPAC to upgrade a data-tier application database is an 'in-place process' as per the documentation.

My question is, how do you go about updating your production databases?

Do you just apply the DACPAC directly to the production database, and then roll back if anything goes wrong?

Obviously you would test this first in a dev, test or staging environment but I'm wondering if there are any other options?

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
digital_fate
  • 567
  • 1
  • 5
  • 15

1 Answers1

2

We used dacpacs, but always tested the rollout against a nearly identical dev/test/uat system first. For really sensitive prod rollouts, sometimes I'd generate the change script/report first to make sure it was going to do what I expected. If that looked good, I'd let it run. (sometimes the process needed advanced permissions from the CICD engine that I didn't have with my account)

Peter Schott
  • 4,521
  • 21
  • 30