Azure Data Studio Migration

Question

Hi, can we use Private Link or Express route During migration to Azure SQL VM from onpremise using Azure Data Studio?

Answer 1

Depending on your network configuration and how your on-premise environment is connected (and firewall ports are open)... YES, that will be possible.

You will find more information here: https://learn.microsoft.com/en-us/azure/dms/pre-reqs

Answer 2

Hi @SaikrishnaE ,

If you meet the below prerequisites across migration scenarios, the answer is yes, you can.

Quote from MS document that BjoernPeters mentioned;

• Create a Microsoft Azure Virtual Network for Azure Database Migration Service by using the Azure Resource Manager deployment model, which provides site-to-site connectivity to your on-premises source servers by using either ExpressRoute or VPN.

• Ensure that your virtual network Network Security Group (NSG) rules don't block the outbound port 443 of ServiceTag for ServiceBus, Storage and AzureMonitor. For more detail on virtual network NSG traffic filtering, see the article Filter network traffic with network security groups.

• When using a firewall appliance in front of your source database(s), you may need to add firewall rules to allow Azure Database Migration Service to access the source database(s) for migration.

• Configure your Windows Firewall for database engine access.

• Enable the TCP/IP protocol, which is disabled by default during SQL Server Express installation, by following the instructions in the article Enable or Disable a Server Network Protocol.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".