This document describes the process of creating a DBLink from an MSSQL database to an Oracle database schema
A database link (DBLink) allows seamless integration and access between two databases, enabling users to query and manipulate data across heterogeneous database systems. In this guide, we will explain how to create a DBLink from an MSSQL database to an Oracle database schema.
Create a Linked Server in MSSQL
- Launch SQL Server Management Studio (SSMS) and connect to the MSSQL instance.
- Expand Server Objects and right-click Linked Servers.
Configure the Oracle Client
- Install the Oracle Client software on the MSSQL server.
- Locate the tnsnames.ora file, typically in the NETWORK/ADMIN directory within the Oracle Client installation path.
- Edit the tnsnames.ora file to include Oracle database connection details
Linked Server: Assign a name for the linked server (e.g., ORACLE_LINK).
Provider: Choose Oracle Provider for OLE DB
Product Name: Enter the same name which u mentioned in Tnsnames.ora file
n Microsoft SQL Server (MSSQL), RPC (Remote Procedure Call) refers to a mechanism that allows executing stored procedures remotely between servers. The terms RPC In and RPC Out in MSSQL
Change RPC and RPC OUT as TRUE
Provide Schema login details for the required database (tnsnames.ora)
Finally test the link works
