SQL Server Performance

Synchronization data between head office and marts

Discussion in 'Performance Tuning for SQL Server Replication' started by tranhiep, Jan 5, 2006.

  1. tranhiep New Member

    I have an issue, please help me achieve a good solution, the requirement is described below.

    Our system consist of 14 marts and 1 (one) head office.

    - Some of marts connected together by Leased line, some of them connected by ADSL in WAN (internet).

    - Total transactions per day: 38.500

    - No. transactions in peak hours: 7.700

    - No. transactions in peak minutes: 140

    - Total customer is 300.000 and yearly growth is about 25%

    - Make sure data stored at least 5 years.

    The data changed (customer buy goods) at marts will be synchronized each other and with the head office by using SQL Replication mechanism periodically.

    Please help me achieve a replication solution meet above requirements and ensure unexpected cases counted as well.

    Thank you very much,
    Hiep Tran
  2. babusamuel New Member

    Hi,

    I think you can use Transactional Replication with Allow Updates Option ON. Also, while setting up the Replication, use the Horizontal Filtering Option so that the Mart1 (for example) recieves only the data they required. If a Mart get connected most of the time with your Publisher, then it is better to use PUSH SUBSCRIPTION in your server or else you can use PULL SUBSRCIPTION.


    Regards,



    N.Babu Godson Samuel
  3. tranhiep New Member

    Thank you for your reply, Samuel.

    Please consult me why we don't choose the Merge Replication solution.

    I have studied in online document of SQL Server Below is topics regarded to this but I think I need more advice from You and database experts.

    1. Merge Replication or Updatable Subscriptions
    2. Implementing Replication Over the Internet

    Thanks,
    Hiep Tran

Share This Page