Overview of the Postgres demo environment

An example migration script - the base version

About Flyway info

About Flyway migrate

Demo: Flyway clean

Querying the flyway_schema_history table

Adding a versioned migration and an undo migration

Deploying with Flyway migrate

Running Flyway undo

Specifying a different configuration file for production

Baselining an existing database before migrating

Intro

Versioning and deployment

Capturing the database state

Demo

Configuring Gradle

Adding migrations

Adding a non-nullable column

Strategies for handling unknown columns

Running the migration

Create a baseline

Creating a new project

Linking to a database

Schema Model

Setting up a shadow database

Creating a new table

Refresh schema model

Apply to database

Generating scripts

Viewing migrations

Conclusion

Demo

Flyway baseline

Flyway schema history table

Adding a new table

Stored procedure migration

Repeating migrations

Running a repeatable migration

Conclusion

New Flyway Functionality

Generate Migration Scripts

Migration Scripts

Flyway Desktop

What is Flyway?

Implementing the first automatic database migration with Flyway

SQL Statements in Flyway

Summary

Outro

Intro

Project creation with Spring Initialzr

Creating a database entity class

Apply custom column names for database entity

Configure DB connection

Flyway principles: the first migration script

Populate tables with Flyway script

Modify column data type

Change a column name

Add a new column to existing tables

Set default values for the new column for old entities

Summary or how-it-works

To sum up

Database migrations

Baseline your database

Generating a DDA script

Flyway configuration

The baseline command

Summary

Conclusion

Database Initialization Options

What are Flyway migrations?

Flyway Migration Script Name

Configuring IntelliJ to use Flyway

How flyway migrations work

Force Checksum Change

Troubleshooting

Deleting Migrations

Starting the application

Conclusion

Intro

Database DevOps survey

What is Flyway?

Demo

Flyway configuration

Adding new tables

Stored procedure migration

Repeating migrations

Benefits of Flyway

Conclusion

About the speaker

Basic functionality of Flyway

Configuring validations

Database Users

Flyway Versioning

What happens with feature branches

Supporting multiple DBMSs

Create two reference files

Versioning migration files

Partitioning the schema

Introduction

Join our community

Why using DB migration

Cleanup the project

Adding Flyway dependency

Setup Flyway

Flyway filename pattern

Running the SQL scripts

What comes next?

Introduction | Quarkus Tutorial

What is FlywayDB ? | Quarkus Tutorial

Create Quarkus project | Quarkus Tutorial

Add flyway quarkus extension | Quarkus Tutorial

Flyway DB configuration | Quarkus Tutorial

Migration SQL script | Quarkus Tutorial

Connect to pgAdmin | Quarkus Tutorial

Flyway DB logs | Quarkus Tutorial

Table flyway schema history | Quarkus Tutorial

Insert SQL script | Quarkus Tutorial

Introduction | Quarkus Tutorial

db.migration packages | Quarkus Tutorial

BaseJavaMigration | Quarkus Tutorial

Implement migrate method | Quarkus Tutorial

Docker-compose | Quarkus Tutorial

Introduction

Download Flyway

Edit config file

Create first migration

Migrate database

Add another migration

Introduction

What are Database Migrations?

Start.spring.io Project

Opening Project in IDE

Link the Spring Boot Blog Application

Setting our Application Properties

Setting up the Resources/db/migration folder

First cut of our Post Model

Creating the First Migration

Running the First Migration

Checking out the Database

Changing the Post Object Model

Adding a Sequence for our Post @Id

Add Post Sequence Migration

Check Updated Database Schema

Add Authority Model

Create Authority Table Migration

Add Account Model

Create Account Table Migration

Add @OneToMany relationship from Account to Post

Add Migration for account_id in Post Table

ManyToMany relationship from Account to Authority

Create Account_Authority Table Migration

A brief discussion about Rollbacks

Wrapping Up