Synchronization data between head office and marts | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Synchronization data between head office and marts

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

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
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