How to run migration to a specific database when application uses multiple databases

Question

My application is connected two databases one primary, and another for reporting purpose, Now I want to to run a migration on reporting database, how to do that?

Answer 1

You should be able to do this with a custom rake task. Checkout this link: ActiveRecord multiple dbs.

This might be helpful too; provides alternative methods: https://stackoverflow.com/questions/1404620