CODEWITHSUNDEEP
sqlazure-devopsdevopscontinuous-deploymentazure-pipelines-release-pipeline
priyanka gharat
priyanka gharat

Reputation: 25

Execute/Deploy SQL script to sql server through Devops. what are possible options?

I am new to Devops. I want to Execute/Deploy SQL script to sql server through Devops(CI-CD). I would like to know what are the possible options to achieve this and which is the preferable one Security wise and performance wise ???

My SQLscript will mostly contains 4, 5 Insert/update Script or 1 Procedure or function.

Upvotes: 0

Views: 4857

Answers (1)

Venkataraman R
Venkataraman R

Reputation: 12959

Generally, it is best practice to deploy the SQL server database code as DACPAC in DevOps in CI/CD manner.

Read more Azure pipelines for SQL deployment

You can refer to the blog posts, which provide step by step for the same:

Upvotes: 2

Related Questions