Flyway for Database Migrations培训

课程大纲

Introduction

Overview of Flyway Features and Architecture

· Core concepts

· Existing plugins

· Supported databases

Getting Started with Flyway

· Setting up the Flyway command-line tool

· Initial configuration

· The 7 basic commands

Migrating with Flyway

· SQL-based migrations

· Java-based migrations

· Script migrations

· Transactions, query results, and schemas

Configuring Flyway

· Parameters

· Environment variables

· Config files and placeholders

· SSL support and authentication

· Secrets management

Executing Database Migrations

· Running the Flyway API

· Executing migrations with Maven plugin

· Executing migrations with Gradle plugin

Integrating Flyway into a Project with Existing Databases

· Data extract and cleanup

· Aligning the databases

· Creating baseline versions

Managing Database Migrations

· Reviewing migration status

· Creating repeatable migrations

· Undoing migrations

· Executing callbacks

· Overriding errors

· Performing dry runs

Exploring Advanced Flyway Features

· Test data management

· Backward compatible migrations

· Zero-downtime migrations