Posts Tagged with SQL Source Control

Moving from application automation to true DevOps by including the database

This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the application code. Read more

Roseanna Whitelegg

10 February 2021

Roseanna Whitelegg

10 February 2021

Customer tips for improving productivity with Redgate products

We recently invited our customers to share their top tips for improving productivity in the first Redgate Tool Tips Swap. This post outlines their hints for using Redgate products to boost productivity and includes relevant training resources to further your learning. SQL Prompt Share formatting settings across your team to consistently format code before... Read more

Amy Burrows

22 July 2015

Amy Burrows

22 July 2015

The key to avoiding database version control problems

It’s a familiar story. Two developers are working on a database, they’re using version control, and there’s a problem. The bigger problem is, they don’t even know they have a problem. As far as they’re concerned, they’re doing everything right. They’ve been using version control, so they can deploy the database changes they’ve been... Read more

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 fund as a corporate... Read more