• Create copy of the table that is identically same with the correct structure. Copy data from the existing table to this new table. Switch the table names.

    After that you might have to do comparison between old and new tables and apply the updates you might have lost during the switch.

    Give a try to this approach!

    Good luck!

    Thanks,

    Amol Naik