SQL Server Performance

Replication question

Discussion in 'SQL Server 2005 Replication' started by california6, Sep 17, 2007.

  1. california6 New Member

    Hello,
    I have the following question about replication and would appreciate, if someone please take a moment to answer it:
    I have a OLTP database (In US) and would like to replicate to another off shore office in India. I was wondering, what would be the best replication model to use here? I.E, merge or transactional? also is there a website which talks about the difference model's?
    appreciated if someone please suggest.
    Thanks,
    cali
    california6, Sep 17, 2007
    #2

  2. ghemant Moderator

    Hi,
    If you need to replicate those data only for reporting purpose snapshot replciation will do(low latency) , else you can go with transactional replication. If your requirement is something that wants Offshore data to be merge with your US - OLTP database and vice versa then go for merge replication. Below are some links for replication
    http://www.replicationanswers.com/
    http://www.mssqlcity.com/Articles/Replic/Replic.htm
    ghemant, Sep 17, 2007
    #3

  3. vipulkumar25 New Member

    Hi hemant,
    If the table size is big then do you suggest snapshot replication will work properly?
    Reagrds,
    Vipul
    vipulkumar25, Sep 19, 2007
    #4

  4. tariq745 Member

    tariq745, Sep 18, 2007
    #5

  5. california6 New Member

    Thank you so much for providing the info. I shall look into it.
    cali
    california6, Sep 18, 2007
    #6

Share This Page