I use transactional type replication in MSSQL server 2005 with many publishers to one subscriber topology.
For that case if table have int data type primary key then successfully table's filed values replicate publishers to subscriber.
But if table have primary key with non int type data type (i.e. varchar or nvarchar or numeric) dataype then how to replicate table's filed values from publishers to subscriber.
Ans also if table have int data type primary key we can set different primary key values ranges using command DBCC CHECKIDENT(Tablename,RESEED,1000) where 3rd parameter is range whatever we set.
It's successfully properly working in Transactional Replication in MSSQL server 2005 from many publishers to one subscriber topology.
But if table have primary key with non int type data type (i.e. varchar or nvarchar or numeric) datatype then how to manage primary key ranges from many publishers to one subscriber.
Please give me right way.
Thanks.