IDENTITY
JamieSoftware
Posts: 2
Pulled down the evaluation copy. Synchronized several tables. But the IDENTITY columns were not 'inserted' on missing rows in the target (ie.. new IDENTITY values created). I looked in the 'Options' area and the 'EXCLUDE Identity Columns' was unchecked. Which I intepreted to mean to INSERT IDENTITY COLUMNS (similar to DTS)....
It created new identities.. Is there someplace else to set the IDENTITY column characteristics ?
Other than that problem it seem to work good (even going from a 2005 set of tables to a 2000 set of tables)...
It created new identities.. Is there someplace else to set the IDENTITY column characteristics ?
Other than that problem it seem to work good (even going from a 2005 set of tables to a 2000 set of tables)...
- Jamie
Comments
Normally the software scripts SET IDENTITY INSERT ON so that the identity values match between the two databases. The only reason I could think of for the identity values being autogenerated is if you'd specifically ignored that particular column from the comparison.