Automatic Fail-over to secondary region similar to Global DocumentDB
Recently, Microsoft introduced a feature "Global DocumentDB database" along with "multi-homing APIs" which provides transparent & automatic fail-over to secondary database with no human intervention.
It will be helpful to have a similar feature for Azure SQL Database where users can enable Geo-Replication and will not have to worry about manual fail-over to secondary in case when Primary / master is unavailable
Alexander (Sasha) Nosov commented
We have the automatic failover feature in public preview. The overview can be found here https://docs.microsoft.com/en-us/azure/sql-database/sql-database-geo-replication-overview#auto-failover-group-capabilities
Gaurav Dhamija commented
That's awesome...Does private preview include Geo-HA for SQL Azure Elastics database pool as well?
Alexander Nosov [sashan@MSFT] commented
Thank you for this feedback. We are already working in this capability and it is available for private preview. If you are interested to try it please send email to sashan at microsoft.com and I will provide additional information.