Should /include:missing reseed?

LittleColinLittleColin Posts: 16
I'm trying to only INSERT data that exists in the source table but doesn't exist in the destination so I used the /include:Missing which seems to almost do what I want (via the command line).

It correctly generates INSERT statements and uses identity insert and correctly does not generate update or delete statements.

However it reseeds the identity based on what was in my snapshot of the production database which is out-of-date by the time we actually perform the rollout and is not necessary.

1. Does the command line allow me to disable the Reseeding?
2. Perhaps it's worth preventing a reseed by default when the /include:Missing switch is used?


Sign In or Register to comment.