Connectivity shift from On Premises to Azure SQL for access tool

Question

Hi All,

Currently we are transitioning from On-Premises SQL DB to an Azure SQL DB.

We have certain configurations/processes setup via Access Tool to load data into OnPrem SQL DB.

Is there any way to update the destination details from OnPrem SQL DB to an Azure SQL DB in Access tool.

Also, can someone share a link to setup a configuration to Azure SQL DB via Access tool and what drivers needs to be installed in the system.

Answer 1

Hi Priya,

You may get help from below link:

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/database/access-to-sql-database-guide?view=azuresql

Regards,