Post reply

Merge Question

  • January 18, 2005 at 4:19 am

    #85347

    Hi Guys,

    I've recently had a merge replication issue.

    I have 3 tables A, B and C

    Table C contains the IDs from A and B and checks that they are present in Tables A and B by means of a constraint on replication.

    I've recently had the case where the replication was trying to insert into Table C before the relevant data had been inserted into A and B hence there was a conflict on the FK constraint.

    Is it possible to order the articles for replication ?

    Many Thanks

    Graeme

  • January 18, 2005 at 5:00 am

    #537799

    Not in SQL Server 2000, assuming they are all part of the same publication. This is possible in SQL Server 2005, but in SQL 2000 the recommendation is to create FKs with the Not For Replication attribute to avoid this type of issue.

    Rgds,

    Paul Ibison (SQL Server MVP)


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • January 19, 2005 at 12:56 am

    #537988

    Thanks for that Paul,

    Yeah I've since been looking at that and that does seem the way.

    What about filter joins, are these any use in this situation?

    Cheers again...Graeme

  • January 19, 2005 at 5:52 am

    #538031

    Using row-level filtering will not help in this situation.  It's mainly used to only replicate rows which meet a certain criteria.

  • January 19, 2005 at 1:41 pm

    #538173

    As far as I understand filters have no effect.

    This article may be of interest to you: http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;307356

    Rgds,

    Paul Ibison (SQL Server MVP)


    Paul Ibison
    Paul.Ibison@replicationanswers.com

  • January 24, 2005 at 8:55 am

    #538769

    you need to use join filters.

    if you haven't solved the problem yet, post a reply and i'll through some stuff together.




    Five Stones IT Consulting and Development

  • January 25, 2005 at 12:58 am

    #538884

    Thanks for that Guys,

    I'm going to try the Not for Replication on the FK option.

    The reason I asked about filter joins is that (if I understand correctly), they enforce RI during replication. But I wasn't sure if this would impact on my problem.

    Interesting little problem...thanks again for your input.

    Cheers..Graeme

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply