Red Gate forums :: View topic - specify comparison key for tbl with a PK in link static data
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 3
SQL Source Control 3 forum

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

Search in SQL Source Control 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
d.roberts



Joined: 13 Sep 2010
Posts: 8

PostPosted: Fri Feb 15, 2013 5:28 pm    Post subject: specify comparison key for tbl with a PK in link static data Reply with quote

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.
Back to top
View user's profile Send private message
d.roberts



Joined: 13 Sep 2010
Posts: 8

PostPosted: Mon Feb 18, 2013 10:40 am    Post subject: Reply with quote

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 Question
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Tue Feb 19, 2013 2:18 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
jamesjd



Joined: 14 Sep 2013
Posts: 1

PostPosted: Sun Sep 15, 2013 5:31 pm    Post subject: Custom comparison key in SQL Source Control Reply with quote

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/39019-sql-source-control/suggestions/4432462-custom-comparison-key-in-sql-source-control

I hope to get some responses soon.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1121
Location: My desk.

PostPosted: Mon Sep 16, 2013 3:07 pm    Post subject: Reply with quote

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 Sad
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group