From the course: Advanced SQL for Application Development
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Automated schema migration with Flyway
From the course: Advanced SQL for Application Development
Automated schema migration with Flyway
- [Instructor] In addition to manually running ad hoc scripts to keep our database schemas up-to-date, we now have tools available to us that can help automate the process. So we'll take a look at a couple. The first one we're going to look at is called Flyway. Flyway is a version control system for database schemas and it's available from flywaydb.org. Flyway is based on SQL scripts, so when you create migration scripts using Flyway, you're basically writing SQL scripts, which then Flyway manages for you and executes for you, relieving you of some of the sort of error-prone tedious manual processes. So Flyway is a good way to migrate databases with code updates in a managed way, and it has other features, like the ability to detect inconsistent and failed migrations. And that's really important, because as we've discussed earlier, one of the things we have to watch out for is having a partially implemented migration or…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.