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

Last updated on Feb 03, 2023

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

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Sep-22-2022 NA New document.

Tell us what went wrong