Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

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.

share|improve this answer
    
we don't have this product and its not free. –  AmmarR Jun 6 '12 at 9:24
    
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
    
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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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