We have our Azure Sql database provisioned in East US and our hot-stand by region is West US.
I know that Azure Sql database supports Geo-Replication and failover groups.
How do I configure the Azure Sql database to support the disaster recovery with automatic failover? Would it impact the connection string?
Use read-write listener for OLTP workload: When performing OLTP operations, use "failover-group-name.database.windows.net" as the server URL and the connections are automatically directed to the primary. This URL does not change after the failover. Note the failover involves updating the DNS record so the client connections are redirected to the new primary only after the client DNS cache is refreshed. Read here for more details.
