Redgate Flyway

30 December 2015

30 December 2015

We don’t need no documentation – automating schema docs in SQL Change Automation

“Understanding the existing product consumes roughly 30 percent of the total maintenance time.” Facts and Fallacies of Software Engineering by Robert L. Glass. You should be documenting your database schema. I know it, you know it. Having current, accurate documentation available accelerates time-to-resolution for faults, aids tech-to-business conversations, and is a regulatory requirement for… Read more

DLM Dashboard

11 December 2015

11 December 2015

Dealing with production database drift

For the SQL Change Automation team, it’s important that we take time out from development, occasionally, to explore some of the issues our customers face when automating database deployment. Following on from previous posts about cross-database and cross-server dependencies, this article shares some of our thoughts about how to deal with… Read more

DLM Dashboard

30 November 2015

30 November 2015

Deploying cross-database dependencies to different environments

The SQL Change Automation team here at Redgate occasionally take time out from development to explore some of the issues our customers face when automating deployment of database changes. As part of one such exercise, we took a closer look at cross-database and cross-server dependencies – these can cause problems when… Read more

Michael Clark

11 August 2015

Michael Clark

11 August 2015

Improving ReadyRoll performance, one line at a time

In our latest release, we sped up ReadyRoll’s performance more than x10 on large databases in two key areas of the product: script generation and project packaging. If you are new to a codebase and haven’t done any performance work on the application before, it is a good idea to… Read more

30 June 2015

30 June 2015

Sometimes the tool just fits – using SQL Change Automation and Octopus Deploy for Data Change Control

From a business risk perspective, data change can be just as significant as code or schema change. Sometimes even more so; an incorrect static (or reference, or master) data change can drive your software’s behaviour more dangerously askew than pretty much any bug can. Imagine treating a retail customer for an investment… Read more

SQL Source Control

Ben Rees

3 June 2015

Ben Rees

3 June 2015

Why our customers are ready for ReadyRoll

We’ve just finished the acquisition of ReadyRoll, a database migrations and deployment tool that makes it easy for software teams to develop SQL Server databases within Visual Studio. That’s the headline news, but why did we do it, and are our customers really ready for it? I’ll answer the second… Read more

DLM

Visual Studio

Alex Yates

26 March 2015

Alex Yates

26 March 2015

Database CI and automated deployment with Jenkins: a Step by Step Tutorial

This post has now been updated by Alex Yates to reflect the latest software. Read the new post. Read more

continuous integration

16 October 2014

16 October 2014

How FlexiGroup uses ReadyRoll

FlexiGroup is a diversified financial services group providing point of sale interest free, no interest ever, leasing, vendor programs, interest free cards and other payment solutions to consumers and businesses. We talk to Damian Haynes, Senior Application Developer at FlexiGroup, about why his team selected ReadyRoll as their database change… Read more

2 December 2013

2 December 2013

Transaction-handling techniques in T-SQL deployments

How are transaction handled when deploying databases with SQL Change Automation? For the most part, we have resisted putting excess structure around the way that changes are deployed to your database. Unlike database projects that use the declarative-style of deployment, which work by synchronizing a source-controlled model of your schema… Read more