What is the best practice of changing Azure Serverless SQL schema and data in CICD pipeline

Question

Hi all,

We are deploying database schema changes from our Development environment to User Acceptance Testing (UAT) and Production using DACPACs within our CI/CD pipeline.

Additionally, we're utilizing Azure SQL Data Sync to synchronize data. However, we've observed that neither schema changes nor data are being updated in the UAT and Production environments, despite there being no errors reported.

Can you suggest the best method to ensure that both the schema and data in the Development environment are accurately replicated to UAT? It does not make sense to use Data Sync?

Answer 1

Hello taka,

Thanks for posting your question in the Microsoft Q&A forum.

I recommend implementing a migration flow in your codebase, where each deployment triggers a migration process to apply database changes. For instance, you can use Entity Framework (EF) in a .NET Core application to handle database migrations.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful