How can we help you today? How can we help you today?

Only update deleted rows when comparing data

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?
rvw
0

Comments

1 comment

Sort by
  • 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
    Robert C
    0

Add comment

Please sign in to leave a comment.