Category: Database Projects
Visual Studio Build in Azure DevOps Pipelines failing on latest Windows vmImage
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 […]
Automate your Database Deployments for Azure SQL using Azure DevOps Releases
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 […]
Database Projects & Azure DevOps – 5 Lessons Learned
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 […]
Remote Azure DevOps Repository Out Of Sync in Visual Studio Database Project
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 […]
Database Projects – Working with SQLCMD variables
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 […]
Database Projects – Working with Pull Requests
In one of the previous blog posts, I described how to merge branches manually (Database Projects – Merging changes). When merging manually, there is no way to revise the development that someone did. If you want to start with peer reviewing during the development process, you can easily do so by using Pull Requests. Quick […]
Database Projects – Getting your database partially in a Database Project
In my previous blog post, we finalized our development phase by deploying our changes to the development environment(Database Projects – Deploying Changes). Since we now have a complete overview of how development can be done, we can look at specific use cases. Quick Overview Use Case Description Step-by-Step Example Important Notices Use Case Description In […]
Database Projects – Deploying Changes
In a previous blog post (Database Projects – Merging changes), we successfully merged our feature branch into our development branch. Now, as a final step in our development process, we want to get our changes deployed to our development environment. In this blog post, we will go through the process step by step to execute […]
Database Projects – Merging changes
In my previous blog post (Database Projects – Making Changes), we successfully executed our first development task in a feature branch. To get our changes to the development environment, we will need to execute a couple of steps which are called merging. Quick Overview What is merging exactly? Merging by example Lessons Learned What is […]
Database Projects – Making changes – Feature Branching
In my previous blog post about Database Projects: “Getting started with Database Projects and Version Control”, I explained how to set up a database project and connect it to Azure DevOps Repos. In this blog post, I will be focussing on how you can start development. Quick Overview What about branching? Feature branching How to […]