Abstract: A method, system, and computer program product configured to perform operations including: detecting, using a first thread associated with a first change data capture (CDC) replication mode, that a database transaction associated with a source database exceeds a threshold time value; based on the detecting, spawning a second thread that is configured to identify log entries associated with the database transaction; confirming the database transaction qualifies as a long transaction based on a commit operation in the log entries associated with the database transaction; based on the confirming, switching to a second replication mode for a table associated with the database transaction; updating the table in a target database using values obtained by executing queries on the source database; and based on the updating the table in the target database, terminating the second thread and switching back to the first CDC replication mode for the table.