C# Programming
09-16-2009, 01:51 PM
What I need to do is reinsert all records exactly as they are from the backup table back into a new table in their corresponding fields.
I am sure there is a better way. The way I would go about doing this is passing a sql reader looping and reinserting the records from 1 table to the other. However this also mess's up the index on the new table.
The new table is structurally different but it has all the same fields as the orgional table, only different order, plus additional fields.
Any good Ideas on what the best way to tackle this? and keep the index's the same?
I am sure there is a better way. The way I would go about doing this is passing a sql reader looping and reinserting the records from 1 table to the other. However this also mess's up the index on the new table.
The new table is structurally different but it has all the same fields as the orgional table, only different order, plus additional fields.
Any good Ideas on what the best way to tackle this? and keep the index's the same?