Automated Database Provisioning in CI/CD Pipelines Using Ansible and Azure DevOps
DOI:
https://doi.org/10.15662/20fna438Keywords:
CI/CD, Database, DevOps, Ansible, Pipeline, Provisioning, Automation, AzureAbstract
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.
References
Marella, N. V. (2024). Optimizing DevOps Pipelines with Automation: Ansible and Terraform in AWS
Environments. International Journal of Scientific Research in Science Engineering and Technology, 11(6), 285
294. https://doi.org/10.32628/ijsrset2410614
[2] Pathak, N. A. (2024). Automating Infrastructure Management: Benefits and challenges of ansible and terraform
implementation across sectors. International Journal of Scientific Research in Computer Science Engineering
and Information Technology, 10(5), 381–394. https://doi.org/10.32628/cseit241051032
[3] Pashikanti, S. (2022). DevOps at Scale: Automating Cloud Deployments with Ansible, AWX Tower and
Terraform. Journal of Artificial Intelligence Machine Learning and Data Science, 1(1), 2041–2045.
https://doi.org/10.51219/jaimld/santosh-pashikanti/449
[4] Akış, T., İpek, B., Yıldız, M., & Gören, A. (2024). The effect of manufacturing defects and license plate on the
energy efficiency of solar vehicles. Academia Green Energy., 1(3). https://doi.org/10.20935/acadenergy7418
[5] Verma, N. P., & Kumar, N. D. L. (2025). Automation of database administration tasks using Ansible.
International Journal for Research Publication and Seminars, 16(1), 481–501. https://doi.org/10.36676/
jrps.v16.i1.210
[6] Kumara, I., Garriga, M., Romeu, A. U., Di Nucci, D., Palomba, F., Tamburri, D. A., & Van Den Heuvel, W. (2021).
The do’s and don’ts of infrastructure code: A systematic gray literature review. Information and Software
Technology, 137, 106593. https://doi.org/10.1016/j.infsof.2021.106593
P, P. T., S, C., & R, D. M. (2021). Devops Methods for Automation of Server Management using Ansible. IJASI
Journal, 1(2), 7–13. https://doi.org/10.5281/zenodo.4782271
[8] S, L. (2022). Automation of server configuration using Ansible. International Journal for Research in Applied
Science and Engineering Technology, 10(6), 4109–4113. https://doi.org/10.22214/ijraset.2022.44840
[9] Sanekshi, R.M. (2022). Cloud-Native Devops for Oracle Databases: Integrating Ci/Cd with Ai-Powered
Pipelines. International Journal for Multidisciplinary Research. https://www.ijfmr.com/papers/2022/5/
38921.pdf
[10] Chijioke-Uche, J. (2022). Infrastructure as code strategies and benefits in cloud computing (Doctoral
dissertation, Walden University). https://scholarworks.waldenu.edu/cgi/viewcontent.cgi?params=/context/
dissertations/article/14536/&path_info=ChijiokeUche_waldenu_0543D_28157.pdf
