dragon-code/migrate-db

Easy data transfer from one database to another

3.2.0 2024-03-15 00:04 UTC

Requires

• php: ^8.0
• ext-pdo: *
• doctrine/dbal: ^3.0
• dragon-code/contracts: ^2.15
• dragon-code/support: ^6.0
• illuminate/contracts: ^8.0 || ^9.0 || ^10.0 || ^11.0
• illuminate/database: ^8.0 || ^9.0 || ^10.0 || ^11.0
• illuminate/support: ^8.0 || ^9.0 || ^10.0 || ^11.0

Requires (Dev)

• ext-pdo_mysql: *
• ext-pdo_pgsql: *
• mockery/mockery: ^1.0
• orchestra/testbench: ^6.0 || ^7.0 || ^8.0 || ^9.0
• phpunit/phpunit: ^9.6 || ^10.0

MIT

• Andrey Helldar

• database
• migration
• migrating
• transfer
• move
• dragon
• andrey-helldar
• dragon-code

README

Easy data transfer from one database to another

Installation

To get the latest version of Migrate DB, simply require the project using Composer:

composer require dragon-code/migrate-db --dev

Or manually update require-dev block of composer.json and run composer update.

{
    "require-dev": {
        "dragon-code/migrate-db": "^3.0"
    }
}

Compatibility

Service	Versions
PHP	^8.0
Laravel	^8.0, ^9.0, ^10.0, ^11.0
Databases	MySQL 5.7+, PostgreSQL 9.5+, MSSQL

Laravel \ PostgreSQL	9	10	11	12	13	14	15
8	✅	✅	✅	✅	✅	✅	✅
9	✅	✅	✅	✅	✅	✅	✅
10	✅	✅	✅	✅	✅	✅	✅
11	✖️	✖️	✖️	✅	✅	✅	✅

Usage

Create a new database and set up both connections in the connections section of the config/database.php file, then run the db:migrate console command passing two parameters:

php artisan db:migrate --schema-from=foo --schema-to=bar

Only Specific Tables

php artisan db:migrate --schema-from=foo --schema-to=bar --tables=table1 --tables=table2 --tables=table3

Exclude Specific Tables

php artisan db:migrate --schema-from=foo --schema-to=bar --exclude=table1 --exclude=table2 --exclude=table3

where:

• foo - Source connection name
• bar - Target connection name

Follow on screen instructions and then command will perform all migrations on the source and destination databases and transfer all records from the old to the new one.

Enjoy 😊

License

This package is licensed under the MIT License.