Use ms SQL to implement distributed query of heterogeneous databases using t-SQL code (original)

/* Use ms SQL to implement the T-SQL code for Distributed Query of heterogeneous databases */

Exec sp_addrole server 'Ms _ SQL ', '', 'sqloledb', '2017. 18.9.20'
Exec sp_add1_srvlogin 'Ms _ SQL ', 'false', null, 'sa', 'capec '/* Create a sqlserver remote connection to the sqlserver database */

Exec sp_addmediaserver 'ora ', 'oracle', 'msdaora ', 'Hj'
Exec sp_add1_srvlogin 'ora ', false, 'sa', 'ccense ',' ****** '/* Create a sqlserver remote connection to the Oracle database */

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 Distributed Query between the local SQL Server and Oracle */

 

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)/* Distributed Query of remote ms SQL and Oracle */