Merging data from an oracle database with an sql data

Question

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

Sibeesh Venu · Answer

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/