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.