Home Keeping existing data
 I had to create another table to extract some columns I my_tables there are many columns but a couple needed to be extracted to be used elsewhere. So the my_new_table exists, but It doesn't have the data that I had in the columns userand guest in my_tables... So I have to rollback my migration and insert some SQL I guess? to take the data from my_tables user & guest ? How to do this please ? class CreateMyNewTables < ActiveRecord::Migration def change create_table :my_new_tables do |t| t.string :user t.string :guest t.references :my_tables, index: true t.timestamps null: false end #how to keep the data I already have in Guest and User remove_column :my_tables, :guest remove_column :my_tables, :user end end