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

d.roberts · February 15, 2013 11:28AM

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 · February 18, 2013 4:40AM

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 B · February 19, 2013 8:18AM

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.

jamesjd · September 15, 2013 12:31PM

I would like to know if there is a workaround for this and also inform you that I have added a request for this feature to be added.

http://redgate.uservoice.com/forums/390 ... ce-control

I hope to get some responses soon.

James B · September 16, 2013 10:07AM

OK, I've had another chat to the development team, and unfortunately it doesn't look like this feature is likely to be implemented any time soon, as there are various other components that need work.

Our only suggested workaround would be to have a separate checkout of your repo to another folder on your PC, and sync between the DB and that folder using SQL Data Compare- you can then manually commit the data records into the repo using Visual Studio/Tortoise SVN etc.

Sorry I don't have better news on this one

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

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk