CODEWITHSUNDEEP
azure-web-app-servicemulti-tenantazure-deploymentazure-deployment-slotsblue-green-deployment
Ozmen
Ozmen

Reputation: 43

Blue-green deployments on Azure for multi-tenancy

Let us say blue and green app services share the same database instances and you can use slots for swapping the applications. How would you handle the schema-breaking changes, as some users may be about to post a request that would not work with the new schema?

From my understanding, it looks like you always have to write backward compatible code that would work in both cases to handle the schema changes, which does not look much ideal to me.

Upvotes: 1

Views: 515

Answers (1)

Rob Reagan
Rob Reagan

Reputation: 7696

There is no magic bullet for rolling back Azure SQL schema changes. Unfortunately you will have to create a script to deploy new updates to your database, and one to roll changes back if things do not go well if you choose to do so. There is a tool called Elastic Jobs that will help you execute scripts across one or more databases in an elastic pool.

Upvotes: 0

Related Questions