sql server replication: Merge Replication doesn't re-propagate changes coming from transactional replication -- sql server replication

Merge Replication doesn't re-propagate changes coming from transactional replication

Vladimir Kofman
6/24/2007 6:46:55 AM

sql server replication:

Hi,

I have the following setup:

OracleDB
SQL2005
SQL2005Express

There's a transactional replication between OracleDB and SQL2005; and there's
a merge replication between SQL2005 and SQL2005Express.
Changes made in OracleDB properly synchronized into SQL2005, but for some
reason Merge Replication does not recognize them (so after synchronization
SQL2005Express doesn't receive those changes). Please note that if I'm inserting/updating
SQL2005 directly, the changes are properly synchronized to SQL2005Express
- so merge replication setup is OK...

Please help,
Vladimir Kofman

Re: Merge Replication doesn't re-propagate changes coming from transactional replication

Vladimir Kofman
6/25/2007 12:00:00 AM

Hi,

If anyone interested I just found the answer at http://msdn2.microsoft.com/en-us/library/ms152559.aspx
:

"If an article is published in a transactional publication and a merge publication,
ensure that the @published_in_tran_pub property is set to TRUE for the merge
article" - I tried it, and it indeed did the trick!

Vladimir Kofman

[quoted text, click to view]