Laravel: Copy models/rows from one connection to another

Question

I want to copy an eloquent model from one connection to another.

The way I have done this so far is as so:

$users = User::on('connection1')->where('tenant', 'foo')->get();
User::on('connection2')->insert($users->toArray());

This works most of the time. But there are cases where this does not work. For example:

When the model has $hidden attribute
When the toArray method for a model is overrided

What is a reliable way to simply copy over some rows to another connection?

score 1 · Answer 1 · answered Apr 17 '20 at 13:09

i think i have found a solution for $hidden attribute & overwriting toArray method

 $users = User::on('connection1')->where('tenant', 'foo')->get();

foreach ($users as $user) {
            $usersArray[] = $user->getAttributes();
        }
User::on('connection2')->insert($usersArray);

if you are using mySql i recommend using bulk insert:

https://www.geeksengine.com/database/data-manipulation/bulk-insert.php

score 0 · Answer 2 · answered Jun 28 '19 at 07:35

0

You can leverage the setConection() method on the eloquent model like so:

$users = User::on('connection1')->where('tenant', 'foo')->get();
foreach ($users as $user) {
   $user->setConnection('connection2');
   $user->save();
}

I found this in another stackoverflow question here

answered Jun 28 '19 at 07:35

PtrTon

3,705
2
14
24

This solution will fail if the user doesn't exist on the `connection2` before executing the `save` method – Lloople Jun 03 '20 at 09:20
You can add `$user->exists = false;` before the `save()` to create a non-existent user – Peter Meth Mar 15 '21 at 20:11

Laravel: Copy models/rows from one connection to another

2 Answers2