locked
Nested Merge Article Join Filters RRS feed

  • Question

  • Hi,

    Running SQL Server 2008 R2 SP3 in a merge replication topology, publisher and distributor are on same machine.

    We have a merge article, [dbo].[Table_A], which is specified as a filtered table in our publication.  There are multiple merge article join filters configured against the merge article.  For example:

    Article [dbo].[Table_A]
        Join Filter [dbo].[Table_A_1]
        Join Filter [dbo].[Table_A_2]
        Join Filter [dbo].[Table_A_3]

    Is it possible to create an additional nested level of join filters?  For example:

    Article [dbo].[Table_A]
        Join Filter [dbo].[Table_A_1]
            Join Filter [dbo].[Table_A_1_A]
            Join Filter [dbo].[Table_A_1_B]
        Join Filter [dbo].[Table_A_2]
        Join Filter [dbo].[Table_A_3]

    Any assistance is greatly appreciated!

    Best Regards

    Wednesday, January 22, 2020 10:51 PM

All replies

  • Hi 2012S4,

    Yes, it is possible.

    Best Regards.

    yuxi



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, January 23, 2020 9:22 AM
  • Hi 2012S4,

    Do you solve it?

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Sunday, February 9, 2020 7:53 AM
  • Hi Yuxi,

    We haven't yet had the opportunity to apply these changes real-world, so at this point I can't confirm whether it's just theoretically possible or does actually work.

    Tuesday, February 11, 2020 3:21 PM
  • Hi 2012S4,

    If you have solved the issue,please reply here.

    Best Regards.

    yuxi


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, February 12, 2020 3:31 AM