CODEWITHSUNDEEP
sql-serversql-server-data-toolsproductiondacpacdata-tier-applications
digital_fate
digital_fate

Reputation: 597

Updating production database via DACPAC upgrade

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?

Upvotes: 1

Views: 510

Answers (1)

Peter Schott
Peter Schott

Reputation: 4681

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)

Upvotes: 3

Related Questions