How to deploy SQL Database (and changes) in Bitbucket pipeline to Azure

[Sumit Ranjan]

@Bitbucket team,

I am trying to automate SQL Database deployment using bitbucket pipeline. I am using Azure SQL database. This question was asked earlier but there no direct support. I have checked the community.

Has there been any update on pipeline for this? 

Thanks,

Sumit

[Theodora Boudale]

Hi Sumit and welcome to the community!

Just to give you some context, Pipelines builds that run in Atlassian infrastructure run in Docker containers. For every step of your build, a Docker container starts based on the Docker image you have specified in your bitbucket-pipelines.yml, the repo is cloned in that container, and then the commands of the step's script are executed. When the build finishes, the container gets destroyed.

If Azure offers a CLI or a REST API that can be used for updating the database from a Docker container, then it should be possible to use it from Bitbucket Pipelines as well. This is a question you can ask on an Azure-specific forum or the Azure support team. Azure SQL database is not developed by Atlassian, so I don't know if they offer such a CLI or REST API that you could use from a Docker container running on a different system.

Kind regards,
Theodora