relations (two databases)

Yii 1.1 General Discussion
1

Hello everyone.

I have two models which represent tables from different databases. They work ok but I get problem when I want to set relations between them. I get error that tells that table does not exist.

I tried this in my model


public function tableName()

{

	return 'database_2.shkoly';

}

But I get access error as connections to these databases use different users and passwords.

Please, can anybody help me?

Thanks.

2

From what I know you cannot make a relation to tables from different databases.

3

Is there another way to load necessary data to my dataprovider to use it in CGridView?

4

What if I use mysql temporary table to copy all the data from another database? Does Yii have tools to work with temporary tables?

5

I’ve used temporary table. Slower but works.

Better suggestions are welcome. :)

6

Check this thread… seems you can relate tables from different database - http://www.yiiframework.com/forum/index.php?/topic/9723-cross-database-relations-join-table-cannot-be-found/