SQLTeam.com | Weblogs | Forums

Data Transfer Concept


We have a condition where I need to transfer the data from Oracle to Intermediate SQL and from Intermediate SQL to client SQL. I can not connect Oracle to Client SQL.

Whenever any new records will appear in Oracle i need to transfer to intermediate SQL and from there i need to transfer the new records to client SQL.

Please suggest how can we check if any records exist, I can not implement batch movement


What is Intermediate SQL and what is Client SQL ?