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

Sumit Ranjan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 8, 2023

@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

1 answer

1 vote
Theodora Boudale
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 9, 2023

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
TAGS
AUG Leaders

Atlassian Community Events