What happens if a record, which was previously marked as deleted in the Destination, is reinserted in the SQL Server Source?

If the Change Tracking mode is enabled for the tables in your SQL Server Source, and you delete a record in one of the tables, the __hevo__marked_deleted value for it is set to True in the Destination when the Pipeline runs. If you reinsert the same record with the same primary key in the Source, as the record is already present in the Destination, it is captured as an update instead of an insert. However, the hevo_marked_deleted column value remains as True.

See Also

• Change Tracking

Revision History