Learn how to use Flyway for Automated Database Migrations
A learning path for managing and automating database deployments, from version control, using Flyway.
You’ll need to click on the image once to open it, and then the links in each article box will work.
Key:
- Yellow box = Flyway Community Edition
- Blue box = Requires Flyway Teams Edition
- Red box = Requires Flyway Enterprise
For further information about Flyway:
- Flyway documentation
- Flyway video training courses on Redgate University
Was this article helpful?
Tools in this post
You may also like
-
Article
Using Git Hooks with Flyway
When you’re on your own developing a simple application, managing your migration scripts is not a demanding task; each time you add a script, it gets the next version number in whatever sequence you’ve decided on using. When your application takes off and you find you have a team working on migrations simultaneously, sharing code
-
Article
Scripting Databases with Flyway Enterprise CLI
This article will cover the basics of the Flyway generate command and how it can auto-generate several types of Flyway migration scripts. This includes versioned migrations that, after testing, can be used to deploy changes, and baseline migration and undo scripts that are useful for a range of development tasks.
-
Webinar
Level Up with Flyway - Online Training Hub
Throughout this course, you will explore a broad spectrum of modules focusing on the full Flyway solution, from Development through to Deployment and Test Data Management. Designed as a three-session course, make sure to register at each of the links below to ensure you’re in the know for all three. Module 1: Database Development with
-
Article
How Spawn is revolutionizing development for the unit testing framework, tSQLt
IT consultancy, sqlity.net, specializes in helping organizations get the best performance and business value from their SQL Server estates through Data Platform DevOps. The founder, Sebastian Meine, is also one of the co-creators of tSQLt, the only open source unit testing framework to enable true continuous integration and continuous delivery for SQL Server. We recently
-
Article
Data Container Revisions, Resets and Graduations
Redgate Test Data Manager allows developers to save each new version of a database as a data container revision. After making local development changes to the container, or running tests, they can instantly reset it to its starting revision. They can also load any previous revision and can even 'graduate' a revision to an image, providing a new baseline for ongoing team development. These techniques are especially effective when used in conjunction with Flyway, which automatically tracks the version of every copy of the database.
-
Article
The Uses of Dependency Information in Database Development
Dependency information will allow you to avoid errors during a database build or tear-down, by ensuring you create or remove objects in the right order. It will also help you to avoid future 'invalid object' errors, because it will allow you to check that no database alterations have introduced broken references, during Flyway migrations.