Lesson 5 — Automating database migrations during deployments

Prerequisites and goals

Prerequisites

Theoretical prerequisites

This lesson assumes that you already know the following:

  • Understand the process of performing database schema and data migrations in TYPO3
  • Learn best practices for executing and validating migrations in a TYPO3 environment
  • Understand the role of database migrations within a CI/CD pipeline

Practical prerequisites

Before you start this lesson, please have the following things ready:

  • Perform a database schema and data migration in TYPO3
  • Implement and execute migration scripts or tools for TYPO3
  • Test and ensure that migrations are successful and data integrity is maintained across environments

Goals

Theoretical goals

By the end of this lesson, you should know the following:

  • Understand the importance of automating database migrations during deployments
  • Learn best practices for integrating database migrations into CI/CD pipelines
  • Comprehend the potential risks and how to mitigate them during automated migrations

Practical goals

By the end of this lesson, you should have completed the following:

  • Implement and configure automated database migrations in a TYPO3 deployment pipeline
  • Ensure that migrations are triggered and executed automatically during deployments
  • Test and validate the automation process to ensure reliability and data integrity

Learning resources

Teacher's instructions

Student's instructions