#1066 overall
Flyway Migrations
Pluralsight
1 recommender · 1 thread · recommended in 1 year, 2018 · score 0.7
A Pluralsight course on database schema migrations using Flyway, a pure SQL-based migration tool. It covers how to structure and deploy schema changes safely alongside application code.
One commenter calls it a great course on the proper way to do migrations with Flyway, noting that most of the material applies to any migration tool.
Databases & Data Engineeringpaidvideo lectures#flyway#database migrations#schema changes#deployment#sql
Recommendations by year
20062026
There are various database agnostic schema migration tools that can help. There are rails, django and laravel migrations or alembic if you use python/sqlalchemy. There also pure sql based migration systems such as flyway. There is a great pluralsight course on proper way to do migrations using flyway. Most of it applies to migrations with any migration tool. You might be able to check it out with the free trial. But basically you want to do all your add columns and add tables before deploying a new version of code. Just to make sure the old version still runs. Then after deploying the new version of code. at some point you can delete the unused columns and tables. I also like to have one database object per migration file. That way the cost of each migration is smaller and if the migration fails you don't have to fix a partial migration since each migration operation is atomic.