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
  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
  3. vipulkumar25 New Member

    Hi hemant,
    If the table size is big then do you suggest snapshot replication will work properly?
    Reagrds,
    Vipul
  4. tariq745 Member

  5. california6 New Member

    Thank you so much for providing the info. I shall look into it.
    cali

Share This Page