I have a table in Sybase (destination) that I would like to keep it synced with a table in Oracle (source)

I cannot truncate and populate the table in Sybase because it is used by an application, I can only add new records and update changes, changes only happen to one column.

In my environment I have Sybase, Oracle, SQL Server & .net development

Whats the best, simplest & reliable way to get this task done, should I develop a DTS, a .net app, use linked server of SQL Server or is there a better way?


You could use Oracle Data Integrator for this. See Oracle Data Integrator documentation for a good starting point. If you want you can build this yourself. Change Data Capture can be used. Make a change table in Oracle that receives the change records from the Oracle source and implement the change records to the sybase destination tables.

| improve this answer | |
  • we don't have this product and its not free. – AmmarR Jun 6 '12 at 9:24
  • 1
    you asked for the best , simplest & reliable way to get this task done. That has a price. Coding for Change Data Capture also has a price, lot's of time to solve bugs. – ik_zelf Jun 6 '12 at 10:30
  • That's right @ik_zelf, i want the best way with the tools i have DTS, a .net app or linked server – AmmarR Jun 6 '12 at 10:33
  • 1
    I edited my answer a little. You do need Oracle technology like CDC to get the changes. Use any host language to transfer the changes. In the end data integrator might be a better option, if complexity grows. – ik_zelf Jun 6 '12 at 10:51
  • thanks, I read the link you posted about CDC, it still requires ODI, and as i mentioned we don't have ODI and no plans to buy it – AmmarR Jun 6 '12 at 10:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.