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 |
|
buzzi
Starting Member
48 Posts |
 Posted - 2008-03-28 : 15:16:36
|
Hi all,New to replication I need suggestions on how go about keeping 2 sql servers from different parts of the world to be in sync all times, some latency may be accepted.Here is the senario,we have website hosted in NA and customers from all parts of the world log in to oursystem and does what ever they have to do which will update the sql server databases. as our company is expanding we want to have a same website hosted in eu, so when ever a person logs from eu he will be hitting the webservers in eu and anything he do will go to the SQL database servers that are in eu. Now the problem i have is when one site goes down say NA site goes down, we need to route all the traffic to site in EU that means sql servers in EU. This brings the challenge of both the servers need to be in sync all times.I did some research on merge replication, this might not work because in this concept we have to make 1 server as the master and the others as slaves. Also i need to think in a way that if they want to expand more that means to asia, i will be having another server, these all need to be in Sync. We are using SQL Server 2005 standard edition.I was reading that this can be achived easily with peer-to-peer replication,but is only available in Enterprise edition which is 4times the cost of standard edition.My company is not going to agree for this, so got to do the research and propose a solutionAny help will be greatly appreciated |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-28 : 15:49:26
|
| Yes, you need to have enterprise edition for P2P replication to work.If your requirement is so critical ,why don't your company get enterprise edition. Merge replication will also work but network bandwidth should be really good for this to work. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-28 : 23:47:19
|
| If you only have two server for now, can start with merge replication. Once have more servers (means more business), company may like to pay for enterprise edition. Also check corp license with Microsoft, cost much less per license if you can get that. |
|
|
|
|
|
|
|
|
Sycn databases from different parts of the world