importing data to sql 2008, identity column
Posted on 2011-09-10
I have a set of non related tables in sql server.
columns: productID, product bar code, description
it is populated with values:
1 wewe444 box
300 wewe889 pen
301 weweppo pencil
(productId's are unique in this table)
I have created a relational database with the same columns for product table. I set productID to primarykey and identity column.
am I going to have problem when I import data to this new table?..how productID's are going to be imported to the identity column?
thanks in advance