question

SanthamoorthyM-9171 avatar image
1 Vote"
SanthamoorthyM-9171 asked AnuragSharma-08 commented

Azure SQL MI failover group setup for migration

We have created 2 SQL MIs in different region. I want to migrate the databases from Onpremise SQL server to SQL MI using Azure DMS. Could someone please confirm whether I need to use the primary instance for my migration and need to use primary instance for application connection? How the secondary instance will work if the primary instance is not available? Do we need to change the connection string again to use the secondary instance if primary is not available? please advise on these questions.

azure-sql-databasesql-server-migrationazure-database-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
1 Vote"
AlbertoMorillo answered AnuragSharma-08 commented

Yes, please connect to primary for the DMS migration. In case the primary instance get stuck during the migration like "log shipping in progress" you can failover to the secondary and start the DMS job again, connect to the failover group using the listener endpoint.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @AlbertoMorillo . Can you please confirm how we need to use the FQDN for application connection? FQDN of primary instance or secondary instance? if I'm using primary instance for connection then do i need to change it to secondary instance incase of any issue in primary?

0 Votes 0 ·
AnuragSharma-08 avatar image AnuragSharma-08 SanthamoorthyM-9171 ·

Hi @SanthamoorthyM-9171, apologies for the delay in response.

You can use read-write listener endpoints in case of failover groups. In case of primary failover we dont need to change the connection to secondary manually as it automatically switches all connection to secondary.

Read more in below articles:

Auto-failover groups overview & best practices

Locate listener endpoint

Please let us know if this helps.

1 Vote 1 ·