CODEWITHSUNDEEP
azuredeploymentazure-sql-databaseazure-pipelines
Sindu_
Sindu_

Reputation: 1465

Apply changes automatically from one azure database to another

I am trying to implement source control for database stored procedures. I am using Azure DevOps and I have added all the stored procedures to an Azure Repo.

I am connecting to the Azure Repo through the team explorer in SSMS. I am working on a branch and once the stored procedure changes are added to the master branch I want the changes to be automatically deployed to the production database.

Is this possible using an Azure pipeline?

Upvotes: 0

Views: 194

Answers (2)

Sindu_
Sindu_

Reputation: 1465

The following link has step by step instructions as to how we can set up Azure pipeline to execute the changes from one database to another:

https://microsoft.github.io/PartsUnlimited/iac/200.2x-IaC-CDAzureSQLdbwithVSTSandVS.html

Upvotes: 0

Sajeetharan
Sajeetharan

Reputation: 222722

Yes you can do it with DACPAC

You can follow the following links,

Use tools that help you integrate and deploy your database along your code. Build better apps on any client OS (Windows, Linux, and macOS) using our graphical user interface and command line tools.

DevOps using SQL Server

Continuous Deployment of SQL

Upvotes: 1

Related Questions