Tackling the problem of database version drift

It is known as ‘database version drift’ or ‘database version creep’. For the best of reasons, the version of the...

Setting up continuous integration for your database with Red Gate and AppVeyor

In this post I’ll walk through setting up a hosted continuous integration (CI) system for your SQL Server database. We’ll...

Using Migration Scripts in Database Deployments

A SQL migration script is similar to a SQL build script, except that it changes a database from one version...

How to Automate your Database Documentation

In my previous post, “Automating Deployments with SQL Compare command line” I looked at how teams can automate the deployment...