Azure SQL Database geo-replication includes a set of new features that improve programming and management capabilities for business continuity and disaster recovery scenarios. These enhancements are available for V12 databases, and they include:
- T-SQL syntax for geo-replication
- Failover and failback
- Ability to synchronize security credentials and firewall rules
- Full support of geo-replication for databases in elastic pools
- Configurable performance levels of the secondary database
- Azure Resource Manager API and support of role-based security
- Synchronous PowerShell cmdlets
For more details, please refer to
Spotlight on new capabilities of SQL Database geo-replication.