Hi Louie and welcome to the community!
If you're looking for an automated solution, Bitbucket Pipelines allow you to run builds in order to deploy your code. Builds can run on Atlassian infrastructure or with a runner on your own machine.
During a Pipelines build you can use several tools to deploy all or some of your repo's source code, e.g.
You can deploy code to a server, as long as this server is accessible from the internet (or at least from the IPs used by Pipelines environments if the build runs on Atlassian infrastructure).
After you deploy your code, you can use the ssh-run pipe in order to run a command or script on that server. For the exact command or script you need to run, you'll need to check SQL Server's documentation.
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.