While I announced last month that I’m leaving Redgate, I’ve not gone yet. I have a few bits and pieces to finish off before I go. My last day will be in mid-August and I’ll start working on DLM Consultants full time in September. I’m spending most of my last month helping one of Redgate’s clients to implement a DLM…
Tutorials
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…
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…
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…
Cross database dependencies and automated builds
The first step of continuous integration is to build your software from your source code. The idea is that each time the source code changes you should build/compile your code from scratch to ensure that you can. Why bother? This is the lowest bar of all your tests, there is no point running your unit, UI or load tests if…
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…
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…
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…
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…
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.…