Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imranrao79
Starting Member
1 Post |
 Posted - 2009-01-13 : 08:49:14
|
| Hi,My company want the replication and online solution for their Call Centers and Shop solution with their Warehouse and third party Server hosting.This is two way communication and data will be available all the time and only relevant data of one location move to that specific location but all data will be available to MAIN third party DB Server.Now I am thinking that I use “Merge Replication” for this Scenario because the network conditions are not available all the time and I will take some time delay of 15 to 30 min and add condition on replication data to move only related data to specific location.What you say, is my solution is right or any other alternative is available and what is the best possible solution for this scenario if you recommend.Please help me in this regard I will be very thankful to u. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 17:38:58
|
| Yes,Merge Replication is good in your scenerio. |
 |
|
|
|
|
|
Sugession regarding replication technique