I have an application which is setup as a replication setup. We use Merge replication to merge data between the servers. We are able to synchronize master data successfully. The same is getting reflected in subscriber db. But when synchronizing the Transaction publication, the data is not getting merged at the subscriber. Data changes at the subscriber is getting merged at the publisher, but the transaction data is not getting merged from publisher to subscriber.
Please let us know what could be the problem? Is there any settings to be made on publisher machine, which we are missing out.
Distributor and publisher are on the same machine.