Using Change Data Capture

[Former Member]

I would like to use Change Data Capture (CDC) with the source database on Oracle and the destination data base on SQLServer.  I think it's called SAP replication server.   I read something that said Oracle was supported and that SQL Server would be added as a destination source but I don't know if that is available yet.  Also, if it is, I would like to know if the changes to tables get applied in the same order as they occur in the source database.  The reason I'm asking is that I want to have triggers on the SQLServer tables and the triggers will join to a parent table and I want to make sure the row will be in the parent table.  Can anybody tell me the answer to this?

[venkataramana_paidi]

Hi Rachel,

I have applied CDC using Sybase replication server on Sybase ASE database.   In this case , We have to create the CDC database with the help of power designer scripts. Change data stores in CDC database. While reading the CDC from the source internally it link to the CDC database and give the changed value.

Thanks & Regards,

Ramana.