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.
This was last published in January 2008

Dig Deeper on Oracle development languages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.