Course Outline

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

Troubleshooting

Summary and Conclusion

Requirements

  • Experience with database management and database management systems

Audience

  • Database administrators
  7 Hours
 

Testimonials (4)

Related Courses

Related Categories