SQL Server identity column and imports -
i'll try , explain in simple terms leaving out whys , wheres of how occured.
currently there 2 databases need merged, have same tables etc , in cases lookup tables identical, in cases , in cases records in 1 database have different identity values there equivalent in other db. it's mess.
let on 1 of databases update identity values bu adding 10,000 them , updating related records. import data , yes in cases lookups have same value twice different identities.
the question not regarding above mess :). want know after re enabling identity column have seed values of
1,2,3,4,5 etc , 10001, 10002, 10003 etc. should more rows inserted , continue lets 9999 identity column use 10,000 , 10,004 or sql server complain on next insert identity value used?
i tested simple insert's: have disable identity_insert
first each table want import data
set identity_insert table off
then can insert data original identity column values (which you'll need in order maintain references correctly)
after
set identity_insert table on
sql server continues sequence highest element plus one, in case (after inserting ids 10001, 10002, 10003) continue 10004.
Comments
Post a Comment