Option to delete identical records from Target
Option to delete identical records from Target.
I had the need to find all identical rows and remove them from the target as they shouldnt be there. I had to use the export to CSV, and using the data generator create a table with the 81k id's and then perform a delete in sql managment studio on the temp table to delete them.
It would be so simple an usfull to be able to just select an option to delete identical rows from target in the Data compare or is there an option to control this
I can choose to modify, delete source where not in target but cant delete where identical