data comparison add specific fields only in update sql statements
In "Data Comparison tool", when two tables are compared, the user may wish to create a script to update only one of the i.e. 5 fields that have changes. It would be nice if in the header of the results grid, a checkbox existed next to each field name (only in tab "Different Records") so that the resulting UPDATE statements of the selected lines would contain only the "checked" fields.
-
Nick A. commented
This was partly implemented with the "Sync" column in the comparison's window, but it would be more useful if it existed in the "Sync window" as an option (which fields to update). One may wish to perform a field-by-field update. As is now, he will have to perform as many comparisons as the fields he wishes to update.