HI GUYS

I HAVE 2 DIFFRENT SERVERS(ORACLE(ERP),SQL SERVERS)

I WANT TO COMPARE THESE 2 TABLES IN A BEST AND EASY WAY I CAN CREATE PACKAGE CONTAIN SOURCE LOOKUP ETC

BUT I WANTED TO DO IT IN STORED PROC

HOPE IT IS A CHALLENGING QUESTATION

THANKS IN A

Hi ADKR,

then linked the Oracle server to the SQL Server one and then you can write a stored procedure that for example encapsulates the T-SQL Merge statement (if supported by your SQL Server version).

Is this a one time thing, or an every day thing?