How do i work with two different databases in rails with active records?

Question

I need to use different database connections in different Rails models. Is there a not-so-hacky way to do that?

Any links or search keywords would be great :)

Answer 1

Add new sections to your database.yml e.g.

other_development:   adapter: mysql   database: otherdb_development   username: root   password:   host: localhost  other_production:   adapter: mysql   database: otherdb_production   username: root   password:   host: localhost 

Add a class in lib/other_database.rb

class OtherDatabase < ActiveRecord::Base   establish_connection "other_#{RAILS_ENV}" end 

and then for each model which isn't in the default database subclass from OtherDatabase e.g.:

class MyModel < OtherDatabase    # my model code... end