You can view the detail of the Compare Result by right-clicking a row and selecting Row Detail. This will show you the compare detail for a particular row, which can be a useful alternate way of viewing the results of the compare.
Values which are different are highlighted in yellow. Note that in this example, DATE_JOINED has not been compared so is not highlighted.
You can step though the Compare Results with Prev and Next.
Prev Diff and Next Diff move to the previous/next row which were different. This provides a fast way to move through all the differences in a compare.
If you have large text values, you can double-click a value to be shown the Data Compare Detail window.
Resyncing the two rows
If you are generating a script to resync the two tables,and the rows are different, the buttons Show Resync SQL and Run Resync SQL will be active:
clicking on Show Resync SQL will show you the SQL which will resync these two rows
Run Resync SQL will run the SQL to resync the rows
After running the SQL, the Compare Results will still show the rows as being different - you will need to rerun the compare for this to be updated.
This feature makes it easy for you to select which rows you want to be resynced.
