Oracle On Prem to Azure Sql Database Migration

Rahul 251 Reputation points
2023-10-25T18:54:24.7933333+00:00

Hi,

I am performing the migration from oracle on premises to the azure sql database.

Scenario-1

Oracle- Connected to Self Hosted Integration Runtime

Azure sql database-Connected to Azure Managed Virtual Network Integration runtime

Firewall port open from the ADF SHIR virtual machine to the Azure sql server.

Migration happens successfully.

Question-1-Scenario-2

Oracle- Connected to Self Hosted Integration Runtime

Azure sql database-Connected to Azure Managed Virtual Network Integration runtime

Firewall port open NOT OPEN from the ADF SHIR virtual machine to the other Azure sql server.

Migration does not happens.

It is due to firewall request issues or some other issues.

With oracle on prem connected to the ADFSHIR and Azure sql database connected to Azure Managed Virtual Network Integration runtime can i do the data migration or the above firewall request from ADF SHIR VM to the azure sql server database is necessary ?

While individually i am able to connect to the azure sql database and deploy the scripts using the script activity.

Error Message-ErrorCode=SqlFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot connect to SQL Database. Please contact SQL server team for further support. Server: '', Database: '', User: '*'.**

Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.

Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Data.SqlClient.SqlException,Message=A network-related or instance-specific error

occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is

correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because

the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to

respond.),Source=.Net SqlClient Data Provider,SqlErrorNumber=10060,Class=20,ErrorCode=-2146232060,State=0,Errors=[{Class=20,Number=10060,

State=0,Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server.

The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured

to allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did

not properly respond after a period of time, or established connection failed because connected host has failed to respond.),},],''

Type=System.ComponentModel.Win32Exception,Message=A connection attempt failed because the connected party did not properly

respond after a period of time, or established connection failed because connected host has failed to respond,Source=,'

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,926 questions
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 28,271 Reputation points Microsoft Employee
    2023-10-25T22:21:41.3666667+00:00

    Hello Kashish,

    In your second scenario, you were not able to perform the migration because the firewall port was not open from the ADF SHIR virtual machine to the Azure SQL server. This prevented the integration runtime from accessing the Azure SQL server and performing the migration.

    To perform the migration from Oracle on-premises to Azure SQL Database, you need to make sure the integration runtime has access to the Azure SQL server.

    To resolve this, you can add the IP address of the ADF SHIR virtual machine to the firewall settings on the Azure SQL Database server.

    I hope this helps.

    1 person found this answer helpful.
    0 comments No comments