Monday, March 26, 2012

How to create Database link in MsSqlServer to Oracle8i

Hi All,
Can somebody please help me, how to create database link to Oracle from MsSqlServer200.

Ex:
If I want to view data in both databases at a time then query would be like the following:

dblink name : SqltoOraclelink
table Name : EMP (this could be available in both the databases)

query in MsSqlServer200 EnterpriseManger:
select empname, empno from EMP msemp, emp@.SqltoOracle oraemp where msemp.empname = oraemp.empname

Then this query results the rows from both the databases where empname is same in both the tables

My question is: How can I create this Database link "SqltoOraclelink" as I can do the same thing in Oracle.

As this is in urgency, it would be greate if somebody help us asap.

Thanks in Anticipation,
Regards,
RKThis article should help you out:
http://www.databasejournal.com/features/mssql/article.php/3290801

No comments:

Post a Comment