Beginning Database Migrations with Flyway |
In my previous video I explained the difference between Data Migration & Database Migrations. I made a reference to Flyway as a utility that can be used for Database Migrations. In case you haven't see the previous video, the link is below.
Link to previous video in English - • Data Migration vs Database Migrations - Wh...
Link to previous video in Kannada - • Video
In this video, we will learn how to get started with Database Migrations using Flyway.
We are going to do the following -
Download Flyway
Setup a fresh Postgres database using Docker
Download sample migrations from GIT Repo
Understand Versioned vs. Repeatable Migrations
Run Flyway Migrate command
Review schema history and File checksum concept
IMPORTANT LINKS:
Link to download Flyway CLI page - https://documentation.red-gate.com/fl...
Direct Flyway download link - https://download.red-gate.com/maven/r...
GIT Repo Link - https://github.com/ReachBinduKumar/43...
COMMANDS USED:
Command to run Postgres in Docker
docker run -i -t -d -p 5432:5432 --name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres
Flyway commands
Check Flyway Config - "flyway info - X"
Validate migrations - "flyway validate"
Run Migrations - "flyway migrate"
If you like this video, please remember to Like this video, share it with friends & colleagues and please do subscribe
Link to this same video in ಕನ್ನಡ - • Video
Link to Video List - https://docs.google.com/spreadsheets/...
Link to Telegram Group - https://t.me/dataupskill