Flyway for Continuous Database Delivery

• Experience with database management and database management systems

Audience

• Database administrators
• Developers

Flyway is an open-source database migration tool that automates SQL or Java-based database migrations. Flyway helps software teams manage changes to their databases, simulate updates, and predict potential issues.

This instructor-led, live training (online or onsite) is aimed at database administrators and developers who wish to install, configure, and manage Flyway to track and apply changes in their continuous database delivery efforts.

By the end of this training, participants will be able to implement, track, reverse, and manage database workflows and changes to improve their continuous database delivery.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

Overview of Flyway for Continuous Database Delivery

• Flyway concepts and API
• Shared development databases
• Manual database updates
• Supported platforms

Getting Started with Flyway

• Tracking and applying changes
• Installing and configuring Flyway
• Adding tables
• Changing scripts

Working with Development Workflows

• Establishing a robust development workflow
• Backup and restore
• Database migration
• Migration reversal
• Fixing errors in migration

Working with Reverse Engineering Workflows

• Establishing a robust reverse engineering workflow
• Comparing databases with a backup
• Creating a comparison database from migrations

Pulling Changes with Flyway

• Applying and finding changes
• Database migration on app startup
• Validating past changes on app startup

Working with Delivery Workflows

• Continuous integration
• Testing changes
• Kicking off testing automatically
• Database release pretesting
• Capturing timing information

Transitioning Existing Databases

• Setting up development and production databases
• Alignment strategies to production
• Change scripts
• Marking and migrating productions
• Drift detection

Troubleshooting

Summary and Conclusion