On 2/15/07, Patrick Baselier
<rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:>
>
> Hello all,
>
> What are your experience and thoughts on running migrates on a
> production environment?
> 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
> alter rights.
> But when running the Rails application I want this user to only have
> enough right to perform SQL actions.
I''m not sure if this would work or not, but couldn''t you
create a separate
environment to run your migrations in? Add another entry to
database.ymlfor that environment with the production database and a
different username.
Then all you need to do is force you migrations to run in this "new"
environment.
Not exactly sure how to make all this work, but it seems like it should be
feasible.
At the moment I''m thinking about executing the migrates in
a> pre-production environment and then exporting the database.
>
> --
> Posted via http://www.ruby-forum.com/.
>
> >
>
HTH,
Michael Guterl
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---