Wiki ‐ Azure DevOps ‐ Deploying an Azure SQL Database - mb-infrasyst/db-sql-devops-deploy-project GitHub Wiki

Welcome to the db-sql-devops-deploy-project wiki!

Introduction: This comprehensive wiki serves as a detailed guide for deploying an Azure SQL Database using Azure DevOps. It encompasses vital steps such as code editing in Visual Studio Code, configuring CI/CD pipelines in Azure DevOps, and confirming the deployment using Azure SQL queries.

  1. Code Preparation in Visual Studio 2022 Description: Initiate the process by developing and refining your database tables in Visual Studio. The example includes the addition of TestColumn3 to the Customer table. image

  2. Pushing Code to GitHub Description: Once editing is complete, synchronize your updates to a GitHub repository for version control and collaboration. image

  3. Continuous Integration (CI) Verification in Azure DevOps Description: Ensure the CI pipeline in Azure DevOps is executed flawlessly. The code undergoes rigorous checks for secrets with GitGuardian and is scanned for vulnerabilities using the Mend Bolt extension. image     image

  4. Continuous Deployment (CD) Verification and Azure SQL Server Deployment Description: Verify the successful execution of the CD pipeline in Azure DevOps, focusing on deploying the Dacpac to Azure SQL Server. image     image

  5. Deployment Validation Description: Conduct a thorough authentication of the deployment using Azure SQL queries to ensure accuracy and functionality.. image

Conclusion: This guide meticulously outlines the deployment process of an Azure SQL Database, underscoring the strategic use of Azure DevOps for enhanced automation and operational reliability.

Reference: This Proof of Concept (POC) is based on the following tutorial: https://medium.com/@sumindaniro/use-azure-devops-to-deploy-an-azure-sql-database-2c79570829cf