non-unique comparison key

BenKim

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?

Pete_Ruiz

Hello @BenKim ,

Thanks for reaching out and sorry that you're displeased with SQL Data Compare. We do have the below help article which outlines troubleshooting steps for improving the performance of SQL Data Compare.

https://documentation.red-gate.com/sdc/troubleshooting/common-issues/troubleshooting-comparison-and-deployment-performance-problems

Regarding the first issue mentioned where there's no constraint after setting a unique key, do you mind sharing a bit of an example to help replicate it on our end?

Kind regards,

Pete Ruiz

Redgate Product Support