Course Outline

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

Requirements

  • Experience with database management and database management systems

Audience

  • Database administrators
  • Developers
  14 Hours
 

Testimonials (3)

Related Courses

Related Categories