Post reply

Replication - Transaction + Merge ?

  • April 30, 2004 at 6:12 am

    #359631

    We have a table with the following fields in our local MS-SQL 2000 server;

    1. ID
    2. FirstName
    3. LastName
    4. Age
    5. DateOfBirth

     

    We want to replicate this data to another remote MS-SQL 2000 server meeting the following conditions.

     

    1. New rows added at the local server should get reflected at the remote server.
    2. Changes to Age and DateOfBirth fields (Only these two fields) in the remote server should get merged with the local server.

     

    How can one achieve this?

     

    Thanks in Advance.

    Niranj.

  • April 30, 2004 at 3:25 pm

    #504909

    You can use transaction replication with update subscribers (inmediate or queue).

    Or also transactional replication in both servers (with both would be publishers and subscribers)

    Or only merge replication.

     

    By modifying replication stored procedures (used to progate changes at subscriber) you can only replicate the updates if the columns you need.

  • April 30, 2004 at 11:07 pm

    #504922

    Thanks for the quick response.

    We tried the first three options but with out success. We are getting one or other error while trying to setup updations to merge the Age and DateOfBirth columns back to the local server.

    Help !

     

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

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