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

tyyyy 20 Reputation points

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?

Azure SQL Database
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
914 questions
0 comments No comments
{count} votes

Accepted answer
  1. hossein jalilian 1,505 Reputation points

    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

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful