Deploy SQL Server repository to Live

[Louie Larin]

Good Day!

Just want to check if it is possible to deploy SQL Server repository to Live. I have found video showing pushing changes from SQL Server to bitbucket (https://www.youtube.com/watch?v=FWAx0pdMLfQ) But not able to find pushing the changes to existing database to apply changes to an existing SQL Server Database. Thanks

Regards,
Louie

[Theodora Boudale]

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.

• rsync
• scp
• ftp
• sftp

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