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