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.

Istoric stele

doctrinemigrations

Name: doctrine/migrations
Author: doctrine

View on GitHub

4,770 stele393 fork-uriPHPMIT7 vizualizăriwww.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.

Alternative open-source pentru Migrations

Proiecte open-source similare, clasificate după numărul de funcționalități comune cu Migrations.

flyway/flyway
flyway/flyway
9,844Vezi pe 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
Vezi pe GitHub9,844
cakephp/phinx
cakephp/phinx
4,537Vezi pe 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
Vezi pe GitHub4,537
liquibase/liquibase
liquibase/liquibase
5,527Vezi pe 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
Vezi pe GitHub5,527
sqlalchemy/alembic
sqlalchemy/alembic
4,215Vezi pe GitHub
Alembic is a database schema versioning system and migration tool for SQLAlchemy. It manages incremental updates to database structures using versioned scripts that support both upgrading and downgrading to keep the database and code in sync. The system utilizes a directed acyclic graph for migration management, which allows for non-linear versioning, including branching and merging across multiple root versions. It includes an automated schema diffing tool that compares live database schemas against metadata objects to programmatically generate migration instructions. The tool provides capa
Pythonpythonsqlsqlalchemy
Vezi pe GitHub4,215

Vezi toate cele 30 alternative pentru Migrations

Colecții curatoriate care includ Migrations

Colecții selectate manual în care apare Migrations.

Întrebări frecvente

Ce face doctrine/migrations?

Care sunt principalele funcționalități ale doctrine/migrations?

Principalele funcționalități ale doctrine/migrations sunt: Database Migrations, Schema Evolution, ORM, Schema Version Tracking, SQL Migration Frameworks, Database Schema Synchronization, Migration State Tracking, Database Abstraction Layers.

Care sunt câteva alternative open-source pentru doctrine/migrations?

Alternativele open-source pentru doctrine/migrations includ: 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…