How to deploy local sql database to azure sql db using pipeline

selvauwm

Hi,

I have local development sql database and want to promote it to Azure sql db using pipeline.  Could you please provide me detailed steps/documentation - starting from creating sql project automation to azure pipeline configuration and its deployment?

Thanks in advance for your support.

Thank you!

Selvakumar R

DanC

Hi @selvauwm

This can be quite tricky as you would need to configure the local agent to be able to communicate with your Azure SQL Database which will require some network tweaking which we don't have any documentation on and would be down to yourselves to resolve 

In terms of creating a pipeline in Azure DevOps please see the doc here: https://documentation.red-gate.com/sca/deploying-database-changes/add-ons/azure-devops

For creating a project, depending on your chosen IDE, please see: https://documentation.red-gate.com/sca/developing-databases