specify comparison key for tbl with a PK in link static data

[d.roberts]

I dont want to use the PK as its just an autogenerated int. I want to use 3 other fields, which I can specify in SQL Data Compare Ok.

[d.roberts]

Ok, just to clarify my meaning:

In link static data in SSMS / SQL Src Control, it doesn't give the option to specify the fields to use for the comparison key, and just uses any PK defined in the db itself.

In SQL Data Compare itself it gives the option to specify the fields.

In my particular case there is a PK used for update and delete operations, but the real unique compound keys are 3 string fields.

Is there any way I can get SSC to use these

[james.billings]

Thanks for your post.

Unfortunately I don't think it's possible to specify a custom comparison key in SQL Source Control. I'm double checking there's no workaround (I don't believe there is...) but if I do find anything I'll post back.