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.

Star 历史

doctrinemigrations

Name: doctrine/migrations
Author: doctrine

View on GitHub

4,770 星标393 分支PHPMIT9 次浏览www.doctrine-project.org/projects/migrations.html

Migrations

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.

Migrations 的开源替代方案

相似的开源项目，按与 Migrations 的功能重合度排序。

flyway/flyway
flyway/flyway
9,844在 GitHub 上查看
Flyway is a database schema versioning tool and SQL migration orchestrator. It applies version-controlled schema changes to relational databases using SQL scripts and Java Database Connectivity to ensure environments remain consistent and reproducible. The tool tracks applied migration scripts in a dedicated metadata table to determine which updates require execution. It supports the synchronization of schema versions across multiple different database engines and provides integration for build systems and application frameworks to automate updates during software release processes. Capabili
Javaauroracontinuous-deliverycontinuous-deployment
在 GitHub 上查看9,844
cakephp/phinx
cakephp/phinx
4,537在 GitHub 上查看
Phinx is a PHP database migration and versioning tool used to track and deploy structural changes to database schemas across different environments. It functions as a version control system for databases, allowing structural modifications to be defined and managed through PHP code. The tool provides mechanisms for database schema versioning and rollback, enabling users to undo previously applied migrations and restore a database to a specific previous state. Additionally, it includes a database seeder for populating tables with initial baseline records or dummy data. The system operates as a
PHP
在 GitHub 上查看4,537
liquibase/liquibase
liquibase/liquibase
5,527在 GitHub 上查看
Liquibase is a database schema change management tool and version control system designed to track, manage, and apply versioned database modifications. It functions as a SQL migration framework and DevOps automation utility that integrates database deployments into continuous delivery pipelines and build toolchains. The system enables precise rollbacks and drift detection by recording every modification made to a database schema. It supports the definition of database changes through structured changesets in XML, YAML, or JSON, as well as raw SQL scripts, to ensure consistent deployments acro
Java
在 GitHub 上查看5,527

包含 Migrations 的精选搜索

收录 Migrations 的精选合集。

常见问题解答

doctrine/migrations 是做什么的？

doctrine/migrations 的主要功能有哪些？

doctrine/migrations 的主要功能包括：Database Migrations, Schema Evolution, ORM, Schema Version Tracking, SQL Migration Frameworks, Database Schema Synchronization, Migration State Tracking, Database Abstraction Layers。

doctrine/migrations 有哪些开源替代品？

doctrine/migrations 的开源替代品包括： flyway/flyway — Flyway is a database schema versioning tool and SQL migration orchestrator. It applies version-controlled schema… cakephp/phinx — Phinx is a PHP database migration and versioning tool used to track and deploy structural changes to database schemas… liquibase/liquibase — Liquibase is a database schema change management tool and version control system designed to track, manage, and apply… sqlalchemy/alembic — Alembic is a database schema versioning system and migration tool for SQLAlchemy. It manages incremental updates to… golang-migrate/migrate — This project is a command-line utility designed to manage database schema versioning and automate incremental schema… amacneil/dbmate — Dbmate is a framework-agnostic SQL database migration tool used for tracking, applying, and rolling back schema…