Settings and activity
2 results found
-
476 votes
Thank you everyone for the suggestions and votes for this over the years.
I’d like to surface up a workaround for the “linking” problem which is mentioned in the comments. For the use case of easing pains around environment setup with a large number of databases, we have had customers find success using code based off Alessandro Alpi’s blog post: https://alessandroalpi.blog/2016/06/28/automatically-link-databases-to-red-gate-sql-source-control/
I do understand that this is a broader issue and hear that many of you also want command line or API support for the product in general.
If there are specific scenarios or workflows that would be useful to automate for you, this feedback is also very useful, and if you have details on the type of VCS you use and the workflow (such as a branching model) that it would fit in to, that would be very helpful for us to hear as well.
An error occurred while saving the comment An error occurred while saving the comment 
Justin bird
commented
As a first step, if extended properties exist but MY copy of SSMS isn't linked, couldn't SourceControl just say "you're not set up, do you want to add this link"?
My entire team have had new machines built recently, we've had to re-connect every database :|
Justin bird
supported this idea
·
An error occurred while saving the comment Justin bird
commented
Hi David, sorry didn't realise there was an update...I don't think it matters? What testing I've done, whether I've selected dedicated or shared it still has the same behaviour. I've considered your question...I can see why you wouldn't want it to auto-link if it's a dedicated database, but if it's shared I think it would be useful to either automatically link (or at least be given the option) to the exisiting repository...
-
5 votesJustin bird
shared this idea
·
Just checking in to see whether there's been progress here...having to re-link databases because I now have a new profile gah! To reiterate my point, if you aren't linked to source control yourself, the database still has an extended properties entry which states the location of the current check-in. A "we've identified a location, do you want to re-use it" type question would be most helpful.