We are looking to move from geographically distributed and replicated physical/virtual data machines to SQL Azure.
We would like to have synched/replicated Azure SQL DB instances in multiple regions. I would appreciate if you could answer some questions related to how to achieve this and what to expect:
1. Is Azure SQL Sync the correct approach for geo-replicating Azure SQL Databases?
2. What is the Performance SLA that I can expect for the synchronization? I would like to know the minimum and maximum delay possible for the synchronization. (I can see that the minimum sync frequency is 5 minutes. What would be the sync delay when the sync is triggered every 5 minutes?)
- Edited by SnehanshuAshar Thursday, January 09, 2014 10:00 PM Added clarification