Only update deleted rows when comparing data
rvw
Posts: 14
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?
What is the proper way to handle this?
Comments
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
Red Gate