Managing your schema
Channel: Andrea Ross
Date: 29/06/2015

by Jeremy Smith

Using migrations for consistency, repeatability, and sanity


Keeping track of changes in your database schema can be challenging. In this talk I will discuss the advantages of using Flyway to effectively manage this issue.

Migrations are an essential tool for both developers and administrators. Developers can quickly recreate a database from scratch and incrementally modify their development database along with their code and tests. Similarly, administrators can determine the current state of any database and easily migrate to a newer one. Most importantly, schema and data changes can be thoroughly reviewed and tested before going to production.

In this talk, I will discuss the benefits of using Flyway to manage migrations.

Specifically, I will: - Show why migrations are useful - Introduce Flyway and how to use it - Focus on using Flyway from the command line using migrations written in sql - Help you determine which changes should be in your migrations - Discuss how to create a base migration from your existing database - Cover strategies for dealing with global objects - Show how to integrate Flyway with Jenkins

No Java experience is required for this talk.