class Person < ActiveRecord::Base
  establish_connection(:hr)
end

class Ticket < ActiveRecord::Base
  establish_connection(:bug_tracker)
end

class HR < ActiveRecord::Base
  establish_connection(:hr)
end

class People < HR
  # ...
end

class Resource < HR
  # ...
end

3 Responses to “Connecting to Multiple Databases Using ActiveRecord”

1. mlambie Says:
   October 30th, 2009 at 5:00 pm

   Very cool Radar. I especially like extending AR::Base.

2. almost effortless » Weekly Digest, 11-6-09 Says:
   November 7th, 2009 at 6:57 am

   [...] Connecting to Multiple Databases Using ActiveRecord You can call establish_connection with the key that points to another database config in your config/database.yml file [...]

3. AL Says:
   November 10th, 2009 at 7:11 am

   Good tip. I was able to use establish_connection on the model class, but when I tried to use the extension example:

   class MCK < ActiveRecord::Base establish_connection(:Mydb) end

   class Mckuser < MCK end

   I get an error:

   Table ‘Mydb.mcks’ doesn’t exist: SHOW FIELDS FROM mcks

   I place the mck.rb file on the lib folder.Any help would be appreciated

Leave a Reply