non-unique comparison key

Data compare tool says "add rows ... with non-unique comparison key" although I chose a key set that make each row unique. Key columns are all int. I don't have a constraint on either side.
Comparison is very slow. I only have 100K rows but the table is wide with about 220 columns. If I use BCP, I can copy out and copy in in less than 10 seconds. But with sql data compare, it takes a few minutes. This makes me avoid this tool (data compare) when synchronizing the table.
Is there a way to improve the speed?


Sign In or Register to comment.