Overview
Learn how to integrate database deployments into your DevOps workflow using Azure Pipelines and Visual Studio Database Projects. Explore the process of creating a database project, manually deploying a Dacpac to multiple environments, and setting up automated deployments through Azure DevOps. Discover best practices for custom deployment scripts, build validation, and secure credential management using Key Vault. This comprehensive conference talk from PASS Summit 2019 guides you through combining these technologies to achieve consistent database deployments across all development environments, making it ideal for both newcomers to Azure Pipelines and Database Projects, as well as experienced users looking to incorporate database management into their existing DevOps practices.
Syllabus
DataOps - Deploy SQL Server Databases Using Azure Pipelines - Mike Donnelly
Taught by
PASS Data Community Summit