SQL Developer

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!

Periodic Importing of data from SQL Server into Oracle Database

437788Jul 10 2008 — edited Jul 11 2008

I would like to know how I can use the SQL Developer tool to import data from a SQL Server database across the internet into an Oracle Database on a periodic basis? I understand there is a Migration Workbench, but it seems to be only a one off activity.

What I would really like is to be able to import data for example, very 30 minutes from multiple tables/views in a SQL Server Database into an Oracle Database (overwriting or modifying existing same data) without the need for Heterogeneous Connectivity, as my Oracle Database is not my LAN.

Thank you for your kind ideas and suggestions.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 8 2008

Added on Jul 10 2008

#sql-developer

1 comment

608 views