I need a table to migrate from Oracle to SQL2008. The sequence was 5,1- starting with 5 and increment 1. There are about say 1Million rows currently. This table with 1M rows are not continous with reference to the sequence -say 5,6,7,9,11,12,13,17...and
so on. Transferring the table can be done, but how to ADD the IDENTITY after the data migration? I need your help.
Thanks in Advance
View Complete Post