How will you perform import/export operations using ADO under the MSSQL Database with a Private Endpoint on the Azure Platform?
User Scenarios covered by this automation
- Azure Pipeline should be able to log in to azure platform, should be able to create Database, Should be able to delete Database and Should be able to modify this Database configuration on the fly based on User selected pipeline parameters.
- Azure Pipeline should be able to trigger import/export operation to fetch or save bacpac file of Database under storage account. This Pipeline should also be able to approve Private endpoints created as a part of this operation. Also, should be able to complete after successful operation completion only.
Let’s deep dive into First scenario-based Automation….
Good day to everyone,
Before a couple of days, I had one ask under my project to prepare Automation which can perform Azure Database creation, deletion, export and import operation using Azure pipelines. Situation we had under our environment is that we required to keep our database behind private network endpoints created as a part of Virtual Network, which can be controlled by our client organization.
After searching through numerous documents online including Microsoft, it came to my understanding that there is no direct documentation related to prepare this whole automation. Microsoft documentation can help to achieve success for small individual pieces but whole setup can not be done using this individual documents. After that I took on a task to design, implement and test this whole setup by my own using this smaller setup and deliver it to client.
User Scenarios covered by this automation
- Azure Pipeline should be able to log in to azure platform, should be able to create Database, Should be able to delete Database and Should be able to modify this Database configuration on the fly based on User selected pipeline parameters.
- Azure Pipeline should be able to trigger import/export operation to fetch or save bacpac file of Database under storage account. This Pipeline should also be able to approve Private endpoints created as a part of this operation. Also, should be able to complete after successful operation completion only.
Let’s deep dive into First scenario-based Automation….