I am writing a RoR app against a legacy Oracle database against which
other applications are running. My app will use some existing tables
and will add some. My question is how to handle this and still use
migrations. I obviously never want to run rake db:migrate against the
production db and have it delete any tables that are being used by
other apps (though I wouldn’t mind being able to recreate these in
test), so do I, but would like to use migrations to update the
production db with the new tables.
- Create a test and development database that are copies of
production as my Version 0
- Create migrations only for the new tables
Also, can I use db:schema:dump to get a copy of my production schema
to use for dev/test? If so, I’m not clear what the steps are to do
Appreciate any help - thanks.