Manage Learn to apply best practices and optimize your operations.

How to transfer data from Oracle to MS SQL Server

SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server.

What is the best way to transfer data from Oracle to MS SQL Server on a daily basis in an automated way? The transfer should be as batch process, as well as real time. The configurations are as below: Oracle 9i server on Linux 32 SQL Server 2005 on Windows XP
The simplistic way for you to achieve this is to timestamp DML activity on SQL Server tables. On the Oracle side, keep a small control table tracking when you last refreshed a particular table, and then simply extract the relevant data using Oracle Hetrogeneous Services. You can poll SQL server as often as you like giving near real-time synchronization. There may be a more advanced way within SQL Server to call Oracle stored procedures.

Dig Deeper on Oracle development languages