<div>
We have Timezones on our side, Africa and Australia are never usually working at the same time, and when they are, it's usually different data.<br />
I see there are 3 kinds of replication available. Merge seems like the option that I'm after. Would you have any links or tutorials on setting that up?
</div>


We have Timezones on our side, Africa and Australia are never usually working at the same time, and when they are, it's usually different data.
I see there are 3 kinds of replication available. Merge seems like the option that I'm after. Would you have any links or tutorials on setting that up?

<div>
yes...you can start here: <a href="http://msdn.microsoft.com/en-us/library/ms152746.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms152746.aspx</a><br />
<br />
<a href="http://www.databasejournal.com/features/mssql/article.php/1438231/Setting-Up-Merge-Replication-A-Step-by-step-Guide.htm" rel="ugc">http://www.databasejournal.com/features/mssql/article.php/1438231/Setting-Up-Merge-Replication-A-Step-by-step-Guide.htm</a><br />
<br />
enjoy
</div>


yes...you can start here: http://msdn.microsoft.com/en-us/library/ms152746.aspx [http://msdn.microsoft.com/en-us/library/ms152746.aspx]

http://www.databasejournal.com/features/mssql/article.php/1438231/Setting-Up-Merge-Replication-A-Step-by-step-Guide.htm [http://www.databasejournal.com/features/mssql/article.php/1438231/Setting-Up-Merge-Replication-A-Step-by-step-Guide.htm]

enjoy

<div>
<div class="content wysiwyg-content">
We are running a custom written webapp which relies heavily on it's SQL Database. Due to poor performance across continents, we need to have a 'live copy' of the database running at the other location (as well as a replicated Webapp), but the data between them needs to be syncronised behind the scenes so the users dont see any performance degredation.<br />
<br />
Would we need SQL 2008 Enterprise edition to facilitate the sync?<br />
Is the sync automatic once it's been setup?<br />
<br />
We are really not sure how to begin.
</div>
</div>


We are running a custom written webapp which relies heavily on it's SQL Database. Due to poor performance across continents, we need to have a 'live copy' of the database running at the other location (as well as a replicated Webapp), but the data between them needs to be syncronised behind the scenes so the users dont see any performance degredation.

Would we need SQL 2008 Enterprise edition to facilitate the sync?
Is the sync automatic once it's been setup?

We are really not sure how to begin.

Replicate/Sync two Databases on separate servers

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.