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 -
https://youtu.be/SYaSlxEEHvI
Link to previous video in Kannada -
https://youtu.be/gZOmL_BuF30
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/flyway/flyway-cli-and-api/usage/command-line
Direct Flyway download link - https://download.red-gate.com/maven/release/com/redgate/flyway/flyway-commandline/10.4.1/flyway-commandline-10.4.1-windows-x64.zip
GIT Repo Link - https://github.com/ReachBinduKumar/43-flyway-tutorial
COMMANDS USED:
Command to run Postgres in Docker
docker run -i -t -d -p 54
32: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 ಕನ್ನಡ -
https://youtu.be/1twWOavLX2g
Link to Video List - https://docs.google.com/spreadsheets/d/1GdYvD2pR2Y7sIgN7TOemqHzZw9DETagAwPtzR6RffW0/edit?usp=sharing
Link to Telegram Group - https://t.me/dataupskill