# Another Database Connectivity

**URL:** <https://www.ruby-forum.com/t/another-database-connectivity/196931>\
**Category:** Rails\
**Created:** [April 6, 2009, 10:51am UTC](https://www.ruby-forum.com/t/another-database-connectivity/196931 "2009-04-06T10:51:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![saurabhpurnaye](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ee59a6/32.png) [@saurabhpurnaye](https://www.ruby-forum.com/u/saurabhpurnaye)\
**Post date:** [April 6, 2009, 10:51am UTC](https://www.ruby-forum.com/t/another-database-connectivity/196931/1 "2009-04-06T10:51:42Z")

</div>

Hi All,

I’m trying to connect another database using rails

I made changes in database.yml file

I succeed in that but with same table name,

I’m having two issues regarding that:

1. How to connect the specific table of another database (suppose table  
name is Arthur and it is in database2, I’m working in database1)

2. How to connect database without making changes in database.yml file.

Any feedback appreciated,  
Thanks  
Saurabh

---

<div class="post-metadata">

**Author:** ![saurabhpurnaye](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ee59a6/32.png) [@saurabhpurnaye](https://www.ruby-forum.com/u/saurabhpurnaye)\
**Post date:** [April 6, 2009, 4:19pm UTC](https://www.ruby-forum.com/t/another-database-connectivity/196931/2 "2009-04-06T16:19:27Z")

</div>

On 6 Apr., 10:51, Saurabh P. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> 1. How to connect the specific table of another database (suppose table  
> name is Arthur and it is in database2, I’m working in database1)
> 
> 2. How to connect database without making changes in database.yml file.
> 
> Any feedback appreciated,  
> Thanks  
> Saurabh

Given that you have a single model (Person) that you want to retrieve  
data from a table in another database, you’ld make an initializer that  
you could call people\_connection.rb and put something like this  
inside:

Person.establish\_connection(  
:adapter =\> “mysql”,  
:host =\> “localhost”,  
:username =\> “someuser”,  
:password =\> “secret”,  
:database =\> “somedatabase”  
)

This is covered in the documentation for ActiveRecord::Base:  
[ActiveRecord::Base](http://api.rubyonrails.org/classes/ActiveRecord/Base.html) See the  
“Connection to multiple databases in different models” section.  
Remember, Google is your friend, and always check the manual.

–  
Best regards,  
David K.  
[http://twitter.com/rubyguy](http://twitter.com/rubyguy)