Hello,
I have an Oracle database located on the remote machine and can conenct thru ODBC conenction and I have a SQL Server 2008 Standard edision on another server.
Now, I have to Insert or update or delete the records in SQL Server destination, by comparing with Oracle source. There is a unique key column in that table and last_update column (in both source and destination) which I can use it for comparision.
Is there any method for doing the Incremental load from Oracle Source to SQL Server destination.
Thanks & Regards