Azure devops : Continuous deployment for sql script

1
votes

I have the database table, stored procedures script, once the script file has pushed to TFS, the changes have to be deployed on the database using azure devops.

How to setup SQL script file for build pipeline and release pipeline in Azure devops

thanks in advance,

3
sqlsql-serverazure-devopscontinuous-deployment
Your question is far too broad to get a complete answer here, but you want to start working with Database Projects to facilitate continuous deployment. – iamdave
Hi dave , my question it's not too broad, I have to run the SQL script, using azure devops , SQL Server Database Deployment. – user9264919

3 Answers

1
votes

Where you stuck exactly? Add 'Azure SQL Database Deployment' task from market place to run sql script. Choose 'Deploy type' accordingly.

0
votes

@rAj is correct, when you add a new "Azure SQL Database Deployment' task to your agent Job, you can select to run an inline SQL script: enter image description here

0
votes

For Build pipeline

  1. Add the SQL Server database deploy task
  2. In Deploy SQL Using, choose Sql Query file.
  3. In Sql File, you can specify the location of your Sql file.

enter image description here

For Release pipeline

The process is similar to build pipeline.

enter image description here