It's been a while since the last activity here, but just in case anyone comes across this with a search:

I wasn't able to get around the above issues using Replication....

The PK is a RecID (record ID) that is assigned by the call switch. Each polling application gets the same data, so each subscriber database should have the same...

No; these DBs are the subscribed / merged DBs. I'd like to keep them 'live'. Would the scheme be easier to implement if they were? e.g. Instead...

Chris,

Let me clarify the setup a bit:

There is 1 call switch

There are 2 apps that read the same buffer on the switch

Each app writes to it's...

Thanks for the link and the response, Chris. I read through the optimization procedures and read that the Merge Agent will retry a record that failed a constraint check...