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
Oracle expert Harish Harbham explains how Oracle Streams can be used for replication.
Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?"
A SearchOracle.com member asks, "I have two different relational schemas with me. Can I get an example as to how to integrate them and create a ...