Posted On: Nov 15, 2022
Amazon RDS for SQL Server now supports a linked server to Oracle database. From your RDS for SQL Server instance, you can use linked servers to access external Oracle databases to read data and execute SQL commands. If you have existing solutions that use linked servers to integrate Oracle databases, you can now migrate your SQL Server workloads directly to Amazon RDS.
Now, you can enable a linked server to Oracle by adding a Linked Heterogenous Server (LHS) option to Option Group associated with your instances. After enabling Option Group, the status of your instance will become ‘pending-reboot’. We do not force the instance to reboot after you modify Option Group. This is a new behavior of Option Groups, and you may be familiar with a similar experience from modifying a parameter in Parameter Groups. During the reboot, RDS will install an OLEDB driver on the host. After the reboot, you can configure a linked server using T-SQL statements.
Learn more about how to configure linked servers to Oracle databases from this Blog post, and visit the Amazon RDS SQL Server User Guide for more information.
Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability.