How can we improve SQL Source Control?

Custom comparison key in SQL Source Control

When adding a static table to be managed by SSC the comparison key is automatically selected. Our tables have auto generated INT ID columns as PK used in FK's. In our Static Data tables we have other columns that are unique and for them we have UK’s that we would like to use as the comparison key.

Here is another with the same issue...
http://www.red-gate.com/messageboard/viewtopic.php?t=16498&highlight=comparison+key

I have not found any workaround for this yet at least.
I believe that this would be a great improvement for SSC and would be used by many. If you agree please vote for this feature so that is gets attention.

50 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    James DevineJames Devine shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Bill SchoonmakerBill Schoonmaker commented  ·   ·  Flag as inappropriate

        The documentation seems to imply that you can use an alternate key as a comparison but I have been unable to prove this. I added a unique index to an existing table that already has a primary key then went back into link static data. I thought there would be an option to choose between the existing pk and the newly created unique key but there wasn't a way to do it. This seems to be a very much needed feature so I hope it is implemented soon.

      Feedback and Knowledge Base