This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 62%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
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.
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
An Azure relational database service.
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
Answer accepted by question author
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.
Thanks @Alberto Morillo . 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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 97%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Hi @Santhamoorthy M , 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
Please let us know if this helps.