Jonathan Hickford is a product manager at Red Gate, working on creating tools to support automation of the database delivery process. Before he joined Red Gate he worked running the web technology team of an international broadcaster, who provided new features and the operational management for the consumer facing TV network websites.
It is known as ‘database version drift’ or ‘database version creep’. For the best of reasons, the version of the metadata in production no longer matches what is in source control. Usually, the most serious consequences would be the loss of the changes that were made to vitalize a moribund production system, but it always … Read more
In this post I’ll walk through setting up a hosted continuous integration (CI) system for your SQL Server database. We’ll be using AppVeyor, a cloud hosted CI system with a focus on easy setup for .NET development. On AppVeyor we’ll use Redgate’s SQL CI utility (part of DLM Automation) which makes it easy to build … Read more
A SQL migration script is similar to a SQL build script, except that it changes a database from one version to another, rather than builds it from scratch. Although they're simple in essence, it is worth knowing how to use them effectively for stress-free database updates and deployments. It takes care to get them right, but it is worth the trouble.… Read more
In my previous post, “Automating Deployments with SQL Compare command line” I looked at how teams can automate the deployment and post deployment validation of SQL Server databases using the command line versions of Redgate tools. In this post I’m looking at another use for the command line tools, namely using them to generate up-to-date … Read more