Azure devops : Continuous deployment for sql script

Question

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,

Answer 1

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