Show Compare Detail

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.