DatabaseProjects Archives - Olivier Van Steenlandt

Azure DevOps Pipelines – SQL Server Deploy – One to rule them all

Azure DevOps Pipelines – SQL Server Deploy – One to rule them all

Published on June 19, 2023

In one of my previous blog posts, I used the SQL Server database deploy task to deploy my DACPAC to SQL Server. Unfortunately, this task became deprecated in Release Pipelines. In this blog post, I would like to share the alternative. Additionally, we will be moving from a Classic Release pipeline to a YAML pipeline. The YAML pipeline will be responsible for building and deploying our Database Projects. Quick Overview Why move to YAML? What…

Azure DevOps YAML Pipelines – Deploy to Azure SQL

Published on April 24, 2023

In my previous blog post, we created an Azure DevOps YAML Pipeline to automate our Database Project Build process. In this blog post, we are going to create an Azure DevOps YAML Release Pipeline for Azure SQL. Quick Overview Prerequisites Step-by-step Example —Download Pipeline Artifact —Deploy Dacpac to Azure SQL —Adding the right trigger Considerations Prerequisites If you are just joining this blog post series and you want to follow the step-by-step examples, I advise…

Azure DevOps YAML Pipelines – Building Database Projects

Published on April 17, 2023

In previous blog posts, I explained how to automate the Database Project Build & Deployment process using Azure DevOps (Release) Pipelines. These blog posts focused on setting up as easily as possible using the Classic Editor. In this blog post, I’m going through the steps of setting up a build pipeline using YAML. Quick Overview Why YAML? Step-by-step Example Important Notice Why YAML? We have been creating our deployment pipelines with the classic editor. Why…

Automate your Database Deployments for SQL Server using Azure DevOps Releases

Published on April 3, 2023

In my previous blog post, Automate your Database Deployments for Azure SQL using Azure DevOps Releases, I described how to automate your database deployments for Azure SQL. Now, in this blog post, we are going to take a look at how we can automate deployments for SQL Server. Since the setup is a bit different in comparison with Azure SQL, we will start with the prerequisites first. Quick Overview Prerequisite Step-by-step Example —Installing an Azure…

Visual Studio Build in Azure DevOps Pipelines failing on latest Windows vmImage

Published on March 27, 2023

Problem statement In the past couple of years, I have learned how to work with Azure DevOps Pipelines (Pipelines & Release Pipelines) using the Classic Editor. Last week, I started to play around with Azure DevOps YAML Pipelines. For some reason, I wasn’t able to build my Database Project using the latest vmImage for windows in Azure DevOps. My Pipeline YAML file looked like this: As you can see, I wanted to use the windows-latest…

Automate your Database Deployments for Azure SQL using Azure DevOps Releases

Published on March 22, 2023

In my previous blog post, Automate your Database Builds – Using Azure DevOps Pipelines, we successfully automated our Build process. As a next step, we will be automating our deployment process to Azure SQL. In this blog post, we will go through the process step-by-step to set up our Release pipeline in Azure DevOps and execute our first release just by clicking a button. Quick Overview Prerequisite Step-by-step Example Using Variables in the Release Pipeline…

Automate your Database Builds – Using Azure DevOps Pipelines

Published on March 6, 2023

After we successfully introduced a database development strategy in my previous blog post series, Getting Started With Database Projects & Azure DevOps, we can look at how to introduce a database deployment automation strategy using Database Projects and Azure DevOps Pipelines. As a starter, we will first be implementing a build automation process and in future blog posts, we will go through the different ways of deployment to different environments. On top of that, we…

Database Projects & Azure DevOps – 5 Lessons Learned

Published on February 20, 2023

Almost 5 years ago I made the switch from “traditional” database development using SQL Server Management Studio to a more flexible way of development by using Database Projects and Source Control. In the first few years, I worked with BitBucket as my code management system and for 2 years I’m using Azure DevOps. In my spare time, I’m using GitHub as well. During this transition, I came across a couple of bumps, because I wasn’t…

Remote Azure DevOps Repository Out Of Sync in Visual Studio Database Project

Published on January 30, 2023

Problem statement It’s no big surprise that I’m a big fan of database/dwh development with Database Projects and Azure DevOps. Ever since I started using it, I try to keep my local branches as clean as possible. Since I swapped laptop last year, I started to use a third party tool to manage branches. In the beginning of 2023 I switched over back to Visual Studio to manage branches since for some reason the tool…

Database Projects – Working with SQLCMD variables

Published on January 23, 2023

When I started to explore and use Database Projects, I ran into a specific situation quite fast where I was required to use SQLCMD variables. In this blog post, I will describe what they are, how you can use SQLCMD variables in Database Projects and where this might become very useful for you. Quick Overview Use Case Description What are SQLCMD variables? Practical Example Use Case Description A couple of years ago, I was working…

Tag: DatabaseProjects