Version 12 not correctly finding compare keys

• 
  Dave,
  I had the same problem and also reverted back to 11. I think it has to do with the fact that SQL Data Compare 12 has VERY minimal defaults selected under project options. If you go to project options then hit the "Redgate defaults" button at the bottom you will see that it selects "Include Identity columns". I believe that is your issue. If you then click "Save as my defaults" this should solve your issue.

  jimmywhite October 11, 2016 15:24

  - 0 +
• 
  Thanks for the information - it sounds like there's some problem where the default project options aren't correctly getting set to Redgate defaults or your own defaults - could you confirm that? It's not something we've seen here but we could have a look if that turns out to be the case

  Mark J October 12, 2016 07:56

  - 0 +
• 
  No, once I set them they stuck. My defaults came up fine this morning with the "Include Identity columns" selected.

  jimmywhite October 12, 2016 09:03

  - 0 +
• 
  All,
  You were correct it was the Options that was the issue. It seems odd that out of the box it doesn't either use the Red Gate defaults or import them from a previous version if it exists.
  The default install had only one item checked out of all the possible options. I first tried the Red Gate defaults, then added a couple more to what I'm used to and now it seems to work fine.
  
  Thanks,
  Dave

  ergoface October 12, 2016 12:01

  - 0 +
• 
  Ah, I see - in general, we try to import settings from v11 or use sensible defaults where possible, but it sounds like that might not have been working properly in this case. I'll write up a bug report and see if there's something we can fix here

  Mark J October 12, 2016 12:51

  - 0 +
• 
  Were you loading a project you saved in V11, or did you start a new project in V12 and re-enter the connection info?

  sam.blackburn October 26, 2016 06:21

  - 0 +

Add comment

Please sign in to leave a comment.