3

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,

Improve this question
2
  • 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. Commented May 1, 2019 at 13:17
  • 2
    Hi dave , my question it's not too broad, I have to run the SQL script, using azure devops , SQL Server Database Deployment. Commented May 1, 2019 at 15:22

3 Answers 3

Reset to default
1

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

@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

Improve this answer

Comments

0

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

Improve this answer

1 Comment

This only allows for 1 script to run.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.