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.