Motivations
In most cases, the business is more sensitive to the repair of differential data and prefers manual repair based on repair SQL.
Solution
- add configuration to control whether to output revise SQL
- the revise SQL like:
// diff when have pk or uk
update xxx where pk_or_uk = xxx
// diff when no pk or uk, or configured to output full field matching
update xxx where col1 = xxx and col2 = xxx and ... and coln=xxx
// miss in target
insert into xxx