Only update deleted rows when comparing data

rvw

I have two databases SOURCE and TARGET, with the target db having rows not present in the source db. I need to remove those rows from the target db, including all dependent records in other tables.

What is the proper way to handle this?

Robert C

Hi,

Are you using the command line version, or the GUI?

In the GUI, you can right-click a row in the grid, and choose "Exclude all different" and "Exclude all on left", which should do the trick.

In the command line, have a look at the /ignoredifferent and /ignoremissing options (you can get more details by running SQLDataCompare.exe /help /verbose).

Hope that helps,
Robert