Transaction Replication - How does the Identity range work.

Question

Hi All,&nbsp;&nbsp;I am setting up a transactional replication for MS SQL 2019. The team is using Identitiy columns as the PK on the tables. I know they are a issue when a failover happens.&nbsp;&nbsp;I would like to set my Identity Range for my Publisher to be from 1 to 2 lakhs and in case of failure the subscribr should start from 2 lakhs.&nbsp;&nbsp;&nbsp;Is this possible if yes can anyone help in providing a sample code to do the same.&nbsp;&nbsp;

olafhelper · Answer

Singapore2024&nbsp;see&nbsp;Replicate Identity Columns - SQL Server | Microsoft Learn

singapore2024 · Answer

olafhelper&nbsp;&nbsp;Thanks for your response. But I want to know what values can I set for&nbsp;&nbsp;Publisher Range Size&nbsp;Subscribers Range Size&nbsp;Next Range Starting Value&nbsp;&nbsp;Also If my publisher goes down Will the subcriber use the Seeding from 1 or will it start from the Next Range Starting Value ?&nbsp;Or Do I need to manually update the Seeding everytime it Fails and reset after I restore my Publisher.&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Transaction Replication - How does the Identity range work.

2 Replies

Resources