A simple console tool which helps to migrate database data from one to another using different DB connections.
Defining source and target database connection.
Allows to change target tables names and columns as well.
Transforms data for each processing rows.
When to use
Sometimes you can have an opportunity to make your custom database based on the existing one but in your opinion you can design it in better way for example primary keys are not names simply as id but in the <table_name>_id pattern, or columns values are not exactly what you want.
Add marcinkozak/databasemigrator to composer.json.
Or simply run:
composer require marcinkozak/databasemigrator
To make it available for Laravel open the config/app.php file and add line below.
'providers'=>array(// Other service providers entriesMarcinKozak\DatabaseMigrator\DatabaseMigratorServiceProvider::class,);
Let's suppose that in this case $value stores identical value as the some_column_name column. By using the array_get function we can fetch the desirable primary key and use it as foreign key for the new value inside the map method.
The package has two Artisan methods.
Populating target tables
php artisan database-migrator:populate
Clearing target tables
php artisan database-migrator:clear
1. While developing this package I have had a task about doing migration DB data from MS SQL server to the MySQL. The source database contains polish chars so I have stuck due wrong characters conversions between databases. Till today I do not know how to solve that.