How to deploy SQL Database in Bitbucket pipeline to Azure

Question

Asking for an opinion or direction on the current problem.

We are using bitbucket pipeline to deploy ci/cd web applications to Azure. Now what is remaining - the database, also being hosted on Azure.

From my research - everything on SQL Database Projects deployments usually utilizes Azure DevOps pipelines (connects to github repo, allows plural environments, has a built-in SqlAgent allows deploy SQL db to the target server via dacpac file. It allows CI with every check-in, every time you push changes. Nice!

But what if can not (for some reason) use Azure DevOps and have to utilize Bitbucket pipelines instead. is that possible? how? via scripting? a tool? to call in the command line? Any help - highly appreciated.

Answer 1

Hi, I don't know if it helps but I have found some interesting documentation, perhaps it you can get some insights from them.

SQL Server: https://learn.microsoft.com/en-us/sql/tools/sqlpackage?view=sql-server-ver15

Bitbucket cloud: https://learn.microsoft.com/en-us/azure/devops/pipelines/repos/bitbucket?view=azure-devops&tabs=yaml

Bitbucket server: https://learn.microsoft.com/en-us/azure/devops/pipelines/repos/on-premises-bitbucket?view=azure-devops