I have a transaction publication setup on SQL Server 2014 lets call it (node A) that replicates to SQL Server 2008 (node B), then I use merge replication to synchronize changes from (A) through (B) to a SQL Server CE database on a Win CE devices because (A) doesn't support merge replication to compact framework.

The problem is that changes came from the transaction publication (A) isn't replicating through merge publication (B) into the SQL Server CE database on the Win CE device while if I change anything in (B) database, it's replicating just fine. Am i missing anything?

Please any help would be appreciated.


For anyone who will encounter a similar issue here's what worked for me:

  • Run the following on your merge publication database :
    EXEC sp_changemergearticle 

    @publication = 'MyPublication', 

    @article = 'MyArticle', 

    @property = 'published_in_tran_pub', 

    @value = 'true';

For more info about the problem read this article :https://docs.microsoft.com/en-us/sql/relational-databases/replication/publish/publish-data-and-database-objects?view=sql-server-2017

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.