I tried the answer provided in this post unsuccessfully. The migration just ran against my default database.
How do I migrate a non-default db in Rails 4?
config/database.yml (foo substituted for sensitive values):
personnel_development:
adapter: postgresql
host: foo
database: personnel
username: foo
password: foo
personnel_production:
adapter: postgresql
host: foo
database: personnel
username: foo
password: foo
db/migrate/20150107222716_create_personnels.rb:
class CreatePersonnels < ActiveRecord::Migration
def connection
ActiveRecord::Base.establish_connection("quiz_#{Rails.env}").connection
end
def change
create_table :personnels do |t|
t.string :fn
t.string :ln
t.timestamps
end
end
end
Model:
class Personnel < ActiveRecord::Base
establish_connection "personnel_#{Rails.env}"
end