Post reply

Merge Replication Problem

  • January 8, 2009 at 10:11 am

    #199845

    Hi

    I have 3 SQL database with same tables and fields but having different data. I need to merge all 3 of them on the main server and then replicate on all the three SQL Servers.

    I am running into the some problems

    1. I created the Publisher at the main server and subscribers on the 3 SQL servers (pull operation). Now when I synchronize for the first time subscriber data gets overwritten by the server data and I looses the subscriber database. Is there a way I can add the subscriber data to the sever data.

    2. During merge replication I also looses the data that have same Primary key id from eg say database A has one record with primary key as 1 and database B also has a record with primary key as 1, so when I merge these 2 database I loose the Database B record. Is there a way I can store database B record but with a different primary key.

    Any advice will be of great help

    Thanks

    Gaurav

  • January 18, 2009 at 9:30 pm

    #929010

    Gaurav (1/8/2009)

    1. I created the Publisher at the main server and subscribers on the 3 SQL servers (pull operation). Now when I synchronize for the first time subscriber data gets overwritten by the server data and I looses the subscriber database. Is there a way I can add the subscriber data to the sever data.

    You can add a new table with same structure on the subscribers (without any data), synchronize the subscriber (this will bring all data from publisher) and then push the data from original table to the new table and then re-synchronize.

    2. During merge replication I also looses the data that have same Primary key id from eg say database A has one record with primary key as 1 and database B also has a record with primary key as 1, so when I merge these 2 database I loose the Database B record. Is there a way I can store database B record but with a different primary key.

    Yes you can. It seems default conflict resolver is running.

    Refer BOL ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rpldata9/html/063d3d9c-ccb5-4fab-9d0c-c675997428b4.htm


    Pradeep Singh

Viewing 2 posts - 1 through 1 (of 1 total)

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