Automating Database Migrations With Containers and Git

Automating Database Migrations With Containers and Git

This article focuses on SQL Server, but the same methods support Postgres and MySQL as well.

Managing database migrations for multiple environments and teams can be challenging. This article describes how Git, database containers, and cloned databases, are combined for custom dev, test, and staging environments, each delivered in seconds.

While Git is often used with database containers, this approach introduces two new elements. Rather than restoring databases from backups, or building databases from source, identical secure production database environments are cloned and delivered in seconds. Database clones are writable, and easily incorporate data masking and synthetic test data. The second element is a script manifest file used in creation and application of personalized migration scripts.

A developer can work on a feature branch with a production database clone with feature scripts applied automatically. At the same time, testing can work on a release branch with an identical production database clone, with a set of release scripts applied. A pipeline stage can test a release branch rollback with a third identical secure production database clone, with upgrade and rollback scripts applied automatically.

This article focuses on SQL Server, but the same methods support Postgres and MySQL as well.

database docker containers devops 2020 database application development git repositories

What is Geek Coin

What is GeekCash, Geek Token

Best Visual Studio Code Themes of 2021

Bootstrap 5 Tutorial - Bootstrap 5 Crash Course for Beginners

Nest.JS Tutorial for Beginners

Hello Vue 3: A First Look at Vue 3 and the Composition API

Ever Wondered Why We Use Containers In DevOps?

At some point we've all said the words, "But it works on my machine." It usually happens during testing or when you're trying to get a new project set up. Sometimes it happens when you pull down changes from an updated branch.

Hire Dedicated DevOps Developers

Hire our Dedicated DevOps Developers who have in-depth skills and expertise to develop an interactive and secure web application. Get custom DevOps solutions for your project.

Hire DevOps Developer

Looking to hire top DevOps developers at affordable prices? **[Hire DevOps Developer](https://hourlydeveloper.io/hire-dedicated-devops-developer/ "Hire DevOps Developer")** from **[HourlyDeveloper.io](https://hourlydeveloper.io/...

50+ Useful Kubernetes Tools for 2020 - Part 2

Our original Kubernetes tool list was so popular that we've curated another great list of tools to help you improve your functionality with the platform.

Docker Tutorial for Beginners 8 - Build and Run C++ Applications in a Docker Container

Welcome to this on Docker Tutorial for Beginners. In this video provides an Introduction on C++ development with Docker containers. So we will see How to ship C++ Programs in Docker.