Automated Database Provisioning in CI/CD Pipelines Using Ansible and Azure DevOps

Abstract

This work shows how the DevOps philosophy can be applied to properly automate MsSQL database deployment with Ansible and Azure DevOps. The method ensures an easy way to reuse deployments and protects the safety of the entire system. Using Terraform, Key Vault, monitoring tools, and the solution reduces the amount of work done by hand, helps avoid errors, and makes the CI/CD and cloud ecosystem processes more efficient and compliant.