In this session, you will learn how to create a YAML pipeline for continuous
integration and deployment of an Azure Database in Azure DevOps. In doing so, the pipeline will create a schema drift report in the first phase that needs to be reviewed before approval before the changes are deployed to Dev, Test, and Prod. The dacpac file is then uploaded to the artifact feed for review and debugging purposes. The pipeline uses a customized SSDT project template, which also ensures that the security, such as users and permissions, are applied in an environment-specific way.