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
Comments
2 comments
-
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
-
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.
Add comment
Please sign in to leave a comment.