How to use 2 schema at a same time?

[littlemaster]

I want to use two schema in single rails application, for that how to specify the schema name in model. Tried with following, it was not working.
set_table_name "schemaname.tablename"

schema names:

1. addressbook
2. schedule

Need to fetch the details from addressboook schema and have to get some data from user and need to store it in a 'schedule' schema with all details.

[improvcornartist]

set_table_name "schemaname.tablename" doesn't work because the application is connected to one default schema. It expects whatever you pass to set_table_name to be a table name within the model's schema.

You should be able to get the application to work by setting up a second ActiveRecord connection for whichever is not the default (Base).

# This is the default connection
ActiveRecord::Base.establish_connection(
:adapter => ?mysql?,
:host => ?localhost?,
:username => ?user?,
:password => ?pw?,
:database => db_name
)
# This is the second connection
ActiveRecord::Schedule.establish_connection(
:adapter => ?mysql?,
:host => ?localhost?,
:username => ?user?,
:password => ?pw?,
:database => db_name
)
 

[littlemaster]

It was not working as per expected. I have used database.yml file with specifying 2 schemas.