[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

SQL and Oracle database Integrate

There is an integration to be done between SQL and Oracle database. The is Time and Attendance Audit table in MS SQL which needs to be send real time to Oracle Database table.
 
The options available are as follows would like to know which would be a better one considering Accuracy, Performance, Recoverability, Reliability etc ...
 
Using Trigger on SQL table and transfer real time.
Have an Executable in VB.net, C# or Others which will be scheduled to transfer periodically say every 2,5 .... 10 minutes to oracle table.
Any other better option available
0
Mahmoodeea
Asked:
Mahmoodeea
1 Solution
 
KrtyknmCommented:
Can you use SQL SERVER INTEGREATION SERVICES (SSIS) to integrate the both?
0
 
anillucky31Commented:
You can create link server  and make job to transfer data to oracle server.
0
 
Alpesh PatelAssistant ConsultantCommented:
Create link server or Cdoe SSIS package and schedule it for 5-10 mins interval
0
 
MahmoodeeaAuthor Commented:
Not exactly but helpful
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now