Using 'legacy_db' as an example of the actual name for your old database, would this work?
class Topic extends Eloquent
{
protected $primaryKey = 'token';
public function members()
{
$relation = $this->belongsToMany('Member');
$relation->table = 'legacy_db.legacy_members_table';
return $relation;
}
}
Last updated
1 year ago.
0
Take a look at this to clarify http://fideloper.com/laravel-multiple-database-connections
Last updated
1 year ago.
0
Solution
OK, I figured it out (after some sleep). Thanks @thevelement to point me into the right direction.
Simply specify [database].[table_name] as the second argument of the relation
class Topic extends Eloquent
{
protected $primaryKey = 'token';
public function members()
{
retrun $this->belongsToMany('Member','legacy_db.legacy_members_table');
}
}
Last updated
1 year ago.
0
Was this really resolved? Are you truly using two distinct servers or just two different schemas?
Last updated
1 year ago.
0
I am still unable to do this across two server connections (vs two schemas).
0
You can do it across multiple server connections with Eloquent. It can get tricky when trying to query through Fluent.
0
Sign in to participate in this thread!
Moderators
-
driesvints
Joined 16 Dec 2013
-
joedixon
Joined 23 Jun 2014
-
tvbeek
Joined 8 Jan 2018
-
tomhatzer
Joined 28 Oct 2021
Laravel
Laravel News
Laracasts
Laravel Podcast