IDENTITY

JamieSoftwareJamieSoftware 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)...
- Jamie

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hello Jamie,

    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.
Sign In or Register to comment.