Delete all rows or Truncate of target table
to make a green field before compare. Mostly i use Data compare to refresh data from the live system to the dev/qa/... which is sometimes a mess. So i have to clear the target tables by hand before.
This could be done in a global switch in "Edit project" -> "Options" but during the Deploy workflow I would remind the user and let him uncheck if required.
Or at least make a clipboard copy for the scheme.tablename from the result window to make a manual truncate easier.
1
vote
![](https://secure.gravatar.com/avatar/4a20bc92ba4abd199df33c3b31f0f4d5?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)