Data Management

DPT07 Introduction to Automated Database Deployments with Azure DevOps


2:45pm - 4:00pm

Level: Introductory to Intermediate

Erin Dempster

IT Data Operations Team Lead

Trean Corporation

Moving code from development to QA to UAT and eventually production can be a project in of itself. This is especially true when multiple projects might be across multiple repositories. Keeping track of the correct set of builds for a release can be challenging. With Azure DevOps, this challenge can be eliminated with pipelines. This session will step through the process to build and release multiple projects in the same pipeline. Opportunities for adding approvals will also be covered.

You will learn:

  • Basics of Visual Studio SQL Database projects
  • Understand Azure DevOps areas (boards, repos and pipelines)
  • Basics of Azure Pipelines for SQL Server database deployments