Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Migrating SQL Server SSIS package to Oracle

891464Feb 12 2012

Dear All,

We are using Microsoft SQL server 2005 in our application, we have two separate Server instances where one instance synchronize data from other server table using SQL Server SSIS package. What can be the counterpart of this functionality in Oracle. I have looked into materialized views but in my case the target table will have more columns than the base table, and the query used to get data from base table will extract some values from one of the BLOB type column of base table and then populate target table multiple columns.

Kindly suggest me any solution.

Best Regards

Irfan

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2012

Added on Feb 12 2012

#database-key-features, #replication

0 comments

720 views