You have implemented Database Projects and Azure DevOps for database development successfully in your organization and you want to make your life easier by automating your database deployments? If the answer is yes, this session is for you!

At the beginning of this session, we will do a quick recap of Database Projects and Azure DevOps. Just to make sure that we are all on the same page.

During the session, we will set up an example build and deploy pipeline. Since there are a couple of ways to deploy changes from Azure DevOps to your target database, We will discuss a couple of scenarios and I will show you which method I'm using.

- 1 Pipeline to rule them all
- multi-step deployment

During this session, we will also cover the deployment pipeline differences between SQL Server and AzureSQL.

At the end of this session, you should have all you need to start with database deployment automation.