We have an older version of our product and we want to update to our new product. We have a table that has an id number in it and it is also an identity field with an incrementer. What I want to do is be able to move the data to a new table, have all those numbers stay the same and keep that field type the same. But we are trying to automate this. Is there a way using a SQL statement to do this?