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...
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.redgate.com/fl...
Direct Flyway download link https://download.redgate.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 somepostgres 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