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

austinjoy

when we talk about the microsoft azure pipe line in the local web developemnt and when we take that project to azure application development in the live azure server for the example of wordpress in the azure when we install azure app services install in cloud the wordpress not always update fast as posible, if you change anything in wordpress ftp in azure the changeing file not update due to the azure pipe line once you update the process of the azure pipe line you can migrate the server of the azure cloud.