1

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?

marc_s
  • 9,052
  • 6
  • 46
  • 52
AmmarR
  • 2,826
  • 3
  • 28
  • 33

1 Answers1

1

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.