Oracle CDC by Attunity (SQL 2012) does not handle updated primary keys correctly - by stefang_1234

Status : 


Sign in
to vote
ID 774367 Comments
Status Active Workarounds
Type Bug Repros 1
Opened 12/14/2012 8:00:32 AM
Access Restriction Public


When a table has CDC enabled and the primary key is updated this should be treated as a delete followed by an insert. This is the behavior you get with SQL Server CDC, but Oracle CDC registers this as a normal update.

This problem makes it impossible to use cdc.fn_cdc_get_net_changes_<capture_instance> and MERGE to implement a simple replication.
Sign in to post a comment.
Posted by TRyanSkinner on 7/18/2013 at 12:32 PM
Ping? It's been 6 months since the last comment. Any word on this?
Posted by Faiz VP on 1/21/2013 at 2:36 AM
I haven't started implementing it yet but can anyone else verify that this bug exists?