What are your experience and thoughts on running migrates on a
Since Rake is using the configuration from database.yml it uses the same
username as my Rails app. So if my migrates are altering the database
(add columns, etc.) this user has to be granted with drop, create and
But when running the Rails application I want this user to only have
enough right to perform SQL actions.
At the moment I’m thinking about executing the migrates in a
pre-production environment and then exporting the database.