doctrine/migrations
Migrations
This project is a database version control system and schema evolution manager designed to track and apply incremental changes to database structures. It serves as a tool for versioning SQL database migrations using both programmatic PHP classes and SQL scripts.
The system is designed specifically for integration with the Doctrine Object Relational Mapper for PHP, allowing database schemas to evolve incrementally without data loss through reversible migration steps.
It covers capabilities for automated database migrations, environment synchronization, and schema versioning. These features facilitate the integration of database updates into application deployment workflows to ensure consistency across development, staging, and production environments.
Features
- Database Migrations - Provides a system for versioning and applying incremental schema changes to database structures.
- Schema Evolution - Manages the evolution of database structures incrementally using reversible migration steps to prevent data loss.
- ORM - Designed to work specifically with the Doctrine ORM to generate and manage database schemas.
- Schema Version Tracking - Manages incremental database updates by storing sequential version numbers in a dedicated tracking table.
- SQL Migration Frameworks - Automates database schema updates using a combination of versioned SQL scripts and programmatic PHP classes.
- Database Schema Synchronization - Ensures development, staging, and production databases share the same structure through versioned migration scripts.
- Migration State Tracking - Tracks which schema versions have been applied to the database to determine which remaining scripts need execution.
- Database Abstraction Layers - Implements an architectural layer that allows SQL migrations to be executed across different database vendors without modifying the source files.
- Database Schema Version Control - Applies version control primitives to track every modification made to the database schema.
- Command Line Interfaces - Provides a console application for executing and managing database migrations from the command line.
- Source File Mapping - Maps PHP migration classes to specific database version steps by scanning designated directories.
- Deployment Workflows - Facilitates the integration of database structure updates into continuous deployment pipelines to ensure schema compatibility.
