Option to Autoselect Identity Columns for Matching

mglenn

I only use SQL Data Compare occasionally, so this may already exist, but I could use a per-session option to automatically use an Identity column for matching when no primary key is set. One of our vendors has over 300 of these in a database with over 1000 tables.

chriskelly

Thank you for your suggestions. The tool can automatically select the primary key for comparison but needs user input to select anything else at the moment. I have logged your suggestion for the development team to consider.