# Connection multiply databases and tables

**URL:** <https://www.ruby-forum.com/t/connection-multiply-databases-and-tables/131059>\
**Category:** Rails\
**Created:** [March 5, 2008, 5:40pm UTC](https://www.ruby-forum.com/t/connection-multiply-databases-and-tables/131059 "2008-03-05T17:40:34Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![remco123](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/779978/32.png) [@remco123](https://www.ruby-forum.com/u/remco123)\
**Post date:** [March 5, 2008, 5:40pm UTC](https://www.ruby-forum.com/t/connection-multiply-databases-and-tables/131059/1 "2008-03-05T17:40:34Z")

</div>

Hi,

I have an external (company)database with 2 tables depart, and  
countries, wich i want to use in my rails-app.

Setup:

development (Local):  
adapter: mysql  
database: fly (tables \> pages ect.)  
username: root  
password:  
host: localhost

extern(company):  
adapter: mysql  
database: fly2 (tables \> depart, countries)  
username: root  
password:  
host: localhost

I created a depart model on my local sever

Class Depart \< ActiveRecord ::Base  
set\_table\_name = “depart”  
establisch\_connection :extern  
end

This works fine from my console; looks like this

> > Page.connection.instance\_eval{@config:database]}  
> > “fly”  
> > Depart.connection.instance\_eval{@config:database]}  
> > “fly2”

Because the tables depart, countries is on our central server i set the  
Pluralization off by the “set\_table\_name”

Now i want to connect also to the countries table with the same  
database-connection.

I have read that a creation of an external-class do the job

class External \< ActiveRecord ::Base  
establisch\_connection :extern  
end

class Depart \< External  
end

class Countries \< External  
end

Question: where i define my set\_table\_name for each class??

remco

---

<div class="post-metadata">

**Author:** ![remco123](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/r/779978/32.png) [@remco123](https://www.ruby-forum.com/u/remco123)\
**Post date:** [March 5, 2008, 7:07pm UTC](https://www.ruby-forum.com/t/connection-multiply-databases-and-tables/131059/2 "2008-03-05T19:07:01Z")

</div>

Remco Z. wrote:

> end
> 
> Question: where i define my set\_table\_name for each class??
> 
> remco

In the model.

hth

ilan