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.
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
> 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.
Wednesday, March 7, 2012
Merge Replication doesn't re-propagate changes coming from transactional replication
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment