SQL Server Performance

Reliplication Problem for Child table

Discussion in 'Performance Tuning for SQL Server Replication' started by anilksharma99, Feb 27, 2004.

  1. anilksharma99 New Member

    Hi
    Me and my colleagues were facing a replication problem for a parent-child table combination. Problem is like:

    Let's say we have two table.

    Table1

    ID_1 guid
    Test


    Another table is a child table of table1. The reason we have child tables is
    that they are dynamic. Dynamic in the sense of zero to many relationship
    to parent table. e.g. If table1 is contact table then table 2 will be table for
    phone number where use has a choice to add zero or n numbers of phone
    number.

    Table2
    ID_2 guid
    Test2
    ID_1 guid - foreign key

    While update of record as whole, irrespective of table2 changed or not,
    what we do is to update table1 and delete table2 for that id and insert
    again; very general practise in such scenario.

    Doing that what happens is the table2 will have whole new set of id's.
    Now coming to replication. If the same record got updated offline on online
    then during merge process what happens is that it ends of doubling of
    records in the child tables. As the reason is whole new set of record
    created in Table2 table in offline and inline database.
    Replication will not have any conflict also. However, from business point of
    view it is a logical conflict.

    I was wondering if you had come across such kind of situation. If so, how
    it has been resolved. I would also like to talk about the strategy you have
    used for conflict handling.
  2. satya Moderator

    Have you configured the replication on the database, if so what was the error or information during the process?

    I think Merge Replication may be suitable in this situationhttp://support.microsoft.com/default.aspx?scid=KB;EN-US;307356 as referred in this KBA.

    If not come with any other pointers from your side about type of replication used or to be used.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page