Databases with SSDT: Deployment in CI/CD process with Azure DevOps

When working on a database in SSDT, there is a need to deploy our changes to further environments and at the same time maintain the consistency of databases between environments. During the session, I will present how we can publish the solution manually and then go to the Continuous Integration and Continuous Deployment process using the Azure DevOps environment (formerly VSTS). In addition, we will work on inserting the unit tests, approval steps and the others using Pester and PowerShell in order to gain full automation in our database deployment process.

00:00 Title slide
06:43 Welcoming
08:25 SQLPlayer resources
10:35 DevOps
16:20 SSDT
19:12 Demo 1: Clone repo & create SQL Server Database project
32:54 Demo 1: Automate build step (CI)
43:00 DACPAC file usage scenarios
46:30 SSDT Deployment Pipeline
49:20 Demo 2: Release Pipeline in Azure DevOps
1:03:00 Q&A

💡 Sign up for free materials and tips for 8 weeks:
https://learn.azureplayer.net/ssdt-tips

👨‍🎓 Learn more from my commercial course ($99 only):
https://learn.azureplayer.net/ssdt-es...