We have a problem which involves multiple Windows CE subscribers (SQL CE 3.5) replicating with SQL Server 2005 in merge replication. The subscription has one table.
When a subscriber changes data, it gets published to the server, as expected. When data changes on the server, it gets published to all subscribers, as expected. However, the changes from one subscriber
does not get downloaded to other subscribers. It seems that the server gets the updates, but the other subscriptions seem not to be "notified" of the new changes made by each subscriber.
So these updates get "stuck" at the publisher after being uploaded.
If a new subscriber comes in and replicates the entire table (the first time), then all updates are properly downloaded. If the subscription is re-initialized, then all rows are downloaded correctly. However we cannot do this because it will downgrade the
synchronization performance too much to download the entire table for each synchronization.
Another detail to note is that if we move the database to another database database server instance and create the publication again, the synchronization works properly. Thus it does not seem to be an issue with the subscribers or the database schema, but
rather the configuration of the server itself.
What could be the reason? Where is a good place to start looking to resolve the issue?
Advice appreciated!