The Type of replication I am doing is merge replication and I have a two hop setup where I have
Publisher->Publisher Subscriber(Republishing Server)->Subscriber
and I am also using Web Synchronization from the Republishing Server to the Subscriber
with a PULL setup on the Subscriber.
The subscriber is on SQL 2005 Express SP3 btw and the Publishers are all on sql 2005 SP3.
When I try and create another publication on a table with Automatic Identity Key
management i get the above error.
The reasoning behind wanting to try out having multiple Publisher entries for the same table
is due to the he table in question being a Global table across
multiple companies and each subscriber only cares about data from their company so if i create
a publication for each company then each subscriber consumes less data.
I agree that Replication is a Monster and the less you have to manage the better but as a first step
I would like to give it a test and see how it behaves.
If anyone has any personal experience with this issue and can offer some advice it would be appreciated.