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
Martin T.
shared this idea