SQL Server Performance

SQL Server 2000 replication(1-subs<-3 pubs)

Discussion in 'Performance Tuning for SQL Server Replication' started by Punyabrata, Feb 14, 2007.

  1. Punyabrata New Member

    Hello technocrats,

    Can we configure one Subscriber from 3 publishers mean to say is it possible to update the same database of the subsciber from three different publisher with snapshot replications scheduled at differnt time?

    If yes...please give me a little idea how to proceed.

    Thanks in advance


  2. MohammedU New Member

    Tables on 3 publishers are same or different?
    If they are different, I believe it is possible...

    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. Punyabrata New Member

    Dear MohammedU,

    let me explain the scenario,

    Table A gets updated in Server 1
    Table B gets updated in Server 2
    I want a table C in Server 3
    which needs to get updated from data of the above mentioned tables....
    means merged data.

    thanks

  4. MohammedU New Member

    I believe you can....
    You need to configure the snapshot to delete only matched data from publisher..

    Delete data in the existing table that matches the row filter statement

    Delete the data that matches the data to be replicated from the Publisher in the Subscriber table with the same name as the destination table. Data in the local table that does not match the data to be replicated remains unchanged in the local table.

    Check BOL topic "article Properties, Snapshot Tab"

    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page