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