Option to Autoselect Identity Columns for Matching

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Option to Autoselect Identity Columns for Matching

Postby mglenn » Sun Mar 17, 2013 7:22 pm

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.
mglenn
 
Posts: 16
Joined: Wed Sep 13, 2006 2:36 pm

Postby chriskelly » Mon Mar 18, 2013 11:21 am

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.
Chris Kelly
Technical Support Engineer
chriskelly
 
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests

cron