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

?