Distributed | data | database
/ * t-SQL code to implement distributed query of heterogeneous database using MS
exec sp_addlinkedserver ' ms_sql ', ', ' SQLOLEDB ', ' 172.18.9.20 '
exec sp_addlinkedsrvlogin ' Ms_sql ', ' false ', NULL, ' Sa ', ' capec '/* Create a remote link for SQL Server to SQL Server database * *
exec sp_addlinkedserver ' ora ', ' Oracle ', ' msdaora ', ' HJ '
exec sp_addlinkedsrvlogin ' Ora ', false, ' sa ', ' ccense ', ' Hu Jintao ' * Create a remote link to Oracle database for SQL Server * *
SELECT V_rec. Customerid,rec. Opdt,rec. Collectdt,rec. Upload,rec.opcount Rec_opcount,v_rec.opcount as V_rec_opcount
From Ora. Ccense. REC_CUST_ACC V_rec INNER JOIN
Rec_cust_acc REC on V_rec. CUSTOMERID = REC. CUSTOMERID and
V_rec. Opcount = REC. Opcount
WHERE (REC. UPLOAD = 0/*ms SQL Native vs. Oracle Distributed Queries * *
SELECT V_rec. Customerid,rec. Opdt,rec. Collectdt,rec. Upload,rec.opcount Rec_opcount,v_rec.opcount as V_rec_opcount
From Ora. Ccense. REC_CUST_ACC V_rec INNER JOIN
MS_SQL.LOCALCOST.DBO.REC_CUST_ACC Rec on V_rec. CUSTOMERID = REC. CUSTOMERID and
V_rec. Opcount = REC. Opcount
WHERE (REC. UPLOAD = 0)/* Remote MS SQL and Oracle distributed query * *