I need to be able to have a single rails application that has models
from two different databases.Some models are in database 1 locally and
some are in database 2 in a remote server. I need to be able to have
models, migrations, fixtures and tests for all models and controllers
connected to the two different databases. I am using Rails 2 and I
really have a need for this to work.
Please point me in the direction of a plugin that will suit my needs.
This seems like something that should be allowed in rails by now with a
:database_name => ‘second_database’
but nothing like this exists to my knowledge. Please help me. There has
got to be a solution.
The command you are looking for is establish_connection. You might
want to look at the rails rdoc. Search for “Connection to multiple
databases in different models” in
class SomeModelDB1 < ActiveRecord::Base
class SomeModelDB2 < ActiveRecord::Base
On Dec 10, 3:53 am, Nathan E. <rails-mailing-l…@andreas-
And this will allow me to have fixtures and tests for models that use a