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.
Azure SQL MI failover group setup for migration
Santhamoorthy M
161
Reputation points
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.