Tutorials

FlySQLFeatureImage

Introducing FlySQL, a Flyway and Redgate hybrid that takes the pain out of database migrations

  Contents What is Flyway? What is FlySQL? What problem does FlySQL solve? How does FlySQL solve the problem? A worked example Deployment with Octopus Deploy Get Involved!   What is Flyway? Flyway is a popular open-source migrations-based project format for Database Lifecycle Management (DLM) built by Axel Fontaine (b|t). It’s a very simple tool that enables users to save…

FlywayMigrateSquare

A Flyway step template for Octopus Deploy to migrate databases, with a drift check

tl;dr I’ve built a Flyway Migrate step template for Octopus Deploy. Allows you to easily migrate your Flyway project with Octopus Deploy. It also includes a drift check for the most popular database platforms using the Redgate comparison engines. It’s available on the Octopus Deploy library here: Flyway Migrate step template for Octopus Deploy For more detail about what it is, how…

buildLogSquare

ALM, databases, TFS build vNext (2015) and Redgate: A tutorial for my SQL in the City demo

I’m in Seattle chilling out around PASS Summit, meeting old SQL friends and duelling with jetlag. A couple of days ago I did a talk with Brian Randell MVP (b|t) at SQL in the City. The talk featured a demo of a CI process for SQL Server using Team Foundation Build vNext (TFS 2015) and Redgate’s SQL CI tool (part…

BambooLogo

Continuous Delivery for Oracle Databases, with Atlassian Bamboo and the Redgate DLM Automation Suite for Oracle (part 2)

Welcome to part 2 in this short series. In this post I’ll explain how to extend the Oracle DB continuous integration process I set up in part 1 by adding a release management process that deploys changes to staging or production databases at the click of a button. Objective for part 2 At the click of a button, at a…

BambooLogo

Continuous Delivery for Oracle Databases, with Atlassian Bamboo and the Redgate DLM Automation Suite for Oracle (part 1)

Welcome to part 1 in this short series, where I explain how to set up a continuous integration process for Oracle databases. In part 2 I’ll set up a release management process that allows a user to deploy changes to staging and live databases at the click of a button. Objective for part 1 Whenever a developer commits a change…

User

Source controlling database users

How should you source control database users? This topic came up a couple of times in the last week. Once at the inaugural Redgate database source control training day on Wednesday and once or twice at SQL Saturday Exeter, when somewhere in between the foot jenga, pirate hats and explosive Phil Factor unmasking (if you believe it?) I found some…

Branching

Two different types of “Release Branch”

When devising the first workshop for the new Redgate training program, Steve Jones (b|t) and I got into a bit of a debate about branching. Upon reflection, it’s obvious why. People often use the term ‘release branch’ – but they can mean different things.  It is important to be clear. I did some Googling and I couldn’t find consistent terminology…

SoC logo

Managing performance when working with large amounts of static data with Redgate SQL Source Control

This post is for Redgate SQL Source Control users who have large amounts of data in source control and experience performance issues as a result. The objective:  source control appropriate data All database developers should be keeping their database schema in source control. This is the foundation of any fit for purpose change management process, reliable testing or deployment pipeline.…