Specify an identity Column in a Replication Definition

To create a replication definition for a table that contains an identity column, specify identity as the declared datatype for the column or use a column-level translation to specify identity as the published datatype for the column.

A replication definition, or multiple replication definitions for the same table, may not publish more than one column that has the datatype identity.

If one replication definition publishes a column as identity, another replication definition may publish the column as numeric and avoid having the extra commands sent with an insert for subscribers to the second replication definition.