Option to just use PK columns
By default, Data Compare has all columns selected. That explains why sometimes it will take longer to compare them.
I would like to have an option to say "Just use the columns of the PK" to do the comparison.
In cases where I just want to "merge" the entire record, I just need to know if it already exists or not to them take a decision.
Currently this is possible to achieve by selecting each table and un-select all the other columns. This is a HUGE time-consuming task with dozens of tables.
Having the tool doing it for us will be a huge win!
Let me know if you need more info.
3
votes