• balaji.it02 (3/7/2013)


    Hi

    You have 2 options to perform..

    1) Go for Database Snapshot & update snapshot frequently...

    2) Go for Merge (Peer to Peer) replication for enabling mulitple users to update the data & merge it finally...

    The OP mentioned that the secondary group was for reporting only. Why complicate things exponentially by bringing merge replication into the mix? What is the advantage to that?