Pub: Sql2008R2 Ent
Dis & Sub: SQL2012 Ent
We have few tables with IDENTITY(1,1) NOT FOR REPLICATION NOT NULL.
After setting up replication, I see IDENTITY(1,1) NOT FOR REPLICATION NOT NULL Sub.
My understanding is that the “NOT FOR REPLICATION” clause should help replication to skip “IDENTITY RANGE MANAGEMENT” when setting up the article in the publisher but when I tried to manually add an article (with IDENTITY COLUMN) to the publisher, it forces me setup IDENTITY RANGE MANAGEMNET options.
what’s new is using SQL2012 as the distributer and I suspect that for some reason it is not able to identify the “NOT FOR REPLICATION” option on the publisher table .(It’s a plain guess as I do not know much about replication and especially how 2012 works)