andrey-helldar/
migrate-db
g4t.io

Migrate One Database to Another in a Laravel Project

by Paul Redmond

Migrate DB is a package by Andrey Helldar to migrate one database to another in Laravel apps.

README from andrey-helldar/migrate-db Open on GitHub →

Migrate DB for Laravel

Stable Version Total Downloads License

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, ^12.0, ^13.0
Databases MySQL 5.7+, PostgreSQL 9.5+, MSSQL
Laravel \ PostgreSQL 9 10 11 12 13 14 15 16 17 18
8 ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅
9 ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅
10 ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅
11 ✖️ ✖️ ✖️ ✅ ✅ ✅ ✅ ✅ ✅ ✅
12 ✖️ ✖️ ✖️ ✅ ✅ ✅ ✅ ✅ ✅ ✅
13 ✖️ ✖️ ✖️ ✅ ✅ ✅ ✅ ✅ ✅ ✅

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

For Certain Tables

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

Exclude Certain Tables

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

where:

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.

More from the ecosystem

marcreichel/
laya-php
g4t.io
3 53

LayaPHP: Self-Hosted Text Classification for PHP and Laravel

Classify text in PHP without an LLM bill: typed decisions in 100+ languages, self-hosted. Laravel-ready SDK for Laya, a Jev AI alternative.

ai classification decision-engine
marcreichel/laya-php via Laravel News
Josh-Dovey/
postcodes-laravel
g4t.io
5 9

Postcodes for Laravel: GB Postcode Lookup and Geography Data

Postcodes for Laravel adds typed GB postcode lookups, validation, geography data, distance searches, and test fakes through the GB Postcodes API.

Josh-Dovey/postcodes-laravel via Laravel News
RedberryProducts/
mailbox-for-laravel
g4t.io
4 115

Mailbox for Laravel: Preview and Test Rendered Email

Mailbox for Laravel captures outgoing mail in a local dashboard and lets you test rendered HTML, recipients, and attachments with fluent assertions.

RedberryProducts/mailbox-for-laravel via Laravel News