Guys, I need to drop some references in 4 tables and create columns that contain the data from the tables that are going to be decommissioned. Was I clear? :s I was thinking in some migrations to perform the following steps: Migration X 1.- Create the now column 2.- Insert the new info in the new columns recently created example: update bookings a set booking_status = (select status from booking_statuses b where b.id a.booking_status_id) 3.- Drop FK Rollback 1.- Generate FK 2.- Point each FK to the corresponding record of the parent table 3.- drop the column booking_status of the example. Any suggestions? Rodrigo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---