h8d8now h8d8now - 1 year ago 88
SQL Question

Laravel 5.2 - how to copy user data from external database with different table format

I have created a new project with laravel 5.2 which have

table containing
id, email, password
as provided in
. I also added some fields such as fullname and address.

I also have old project with different table format and fields in its users table. Now, I need to copy / migrate all users information such as email, fullname, etc into my new project using laravel.

I know laravel provides seeding and multiple database connection. But I am not sure if it is ok to use seed with 10K records. Please advise the good way to copy those thousands records.


Answer Source

This is a good candidate for a Console Command.

php artisan make:console YourCommandName

public function handle()
    $mysql2 = DB::connection('mysql2')->select("var1 AS var2...")->get()->toArray();


This is somewhat pseudo code. I haven't tested it, but that's how I would do it.

The other option is to create a new model in a foreach loop.

foreach ($mysql2 as $record)
    $model = new LaravelModel();
    $model->property = $record->property;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download