Post reply

Doing Insert/Update/Delete from Oracle Source to SQL Server Dest.

  • July 16, 2013 at 3:36 pm

    #276111

    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

  • July 16, 2013 at 10:00 pm

    #1633066

    Is there a way to use SSIS?

  • July 17, 2013 at 7:33 am

    #1633282

    Yes, I can use SSIS.. but I'm not sure how to setup the Insert, Update and delete commands in SSIS. In other words... I actually want to compare my source and destination to know what rows changed and apply those changes rows only. As I am using ODBC connection, it's taking more time to download the data.

    Can I use replication btw Oracle to sql server??

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply