Hi there
Currently our company has on-premises Microsoft SQL Server 2016. This SQL Server instance has Linked Server connection to other on-premises database i.e. Oracle database. We use OPENQUERY inside the Store Procedures to do remote live SELECT query.
We intend to move on-premises SQL Server 2016 instances to Azure with below design options and while also many of the on-premises Oracle databases will migrate to AWS Cloud and few will remains on-premises.
(Prefer Design Option 1) Does Azure Managed SQL Server Instance has linked server connection functionality to connect on-premises Oracle database and also cloud AWS Oracle database? If yes, any supporting document please?
(Design Option 2) We get Azure Virtual Machine (VM) with Microsoft SQL Server on it. Does this Azure VM SQL Server has linked server connection functionality to connect on-premises Oracle database and also AWS Cloud Oracle database? If yes, any supporting document please?
NOTE - As Linked Server feature enables us to query remote database tables as live feeds, we are not taking ADF Pipeline into consideration for any data movement.
Thank you!