Loading

Merging data from an oracle database with an sql data

chinedu Nwankwo

Pls i need how can i compare 2 field values from a table in sqlserver with field values from another table in an oracle db ,i.e firstname , and email are common on both databases

Regards

Chinedu Nwankwo

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sibeesh Venu11y ago

I'd create a linked server from SQL Server to the Oracle server, then compare database tables using Except or Union
Or you may need to create a function which will loop through the bath data.

Please up vote and accept if it helped you
Kindest Regards
Sibeesh
http://sibeeshpassion.com/