I have an urgent requirement where I have existing table and the app creates a new table with schema where some of the columns have changed, added or removed. I need to merge these 2 schemas in such a way that it maintains the new schema column orders. Then I need to insert old data into the newly merged schema. How do I accomplish that?
Old Schema: ID, Name, Address, City
New Schema: ID, Name, Address1, Address2, State
Thank you for your time.