Synchronization Wizard has 3 types of records to choose from – Additional, Different, and Missing. What do these mean?
In data comparisons, ApexSQL Data Diff divides all compared data records into one of these 3 categories if the records are not identical. Missing rows are those rows that exist only in a source table/view, while Different rows exist only in a destination table. Different rows are those that have been found to exist in both tables, but are different in some specific values in certain columns. A row is found to be different if the comparison keys for the records are the same, but individual data differences exist beyond that. Additional rows are those rows that exist only in the destination table/view.
