@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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.