Maybe I'm missing something (quite likely) but isn't it possible to link sql source control 3 to an existing set of scripts? We've been using TFS and Sql Compare 9 to source control our database scripts and I'd like to test linking an existing db to these scripts. Is this possible?
Comments
6 comments
-
Create a file called redgate.ssc with nothing in it and save it with the scripts folder.
This will indicate to SQL Source Control that it's a valid scripts folder.
Let us know how you get on.
David Atkinson
Red Gate Software -
Thanks for the response. Unfortunately, that hasn't worked. Here's my scripts folder setup:
https://public.blu.livefilestore.com/y1pwmc7UptnMxDADXpMrMYBhahbINzUzF6we4MsBaQRQ4DC1EIZxUclbS6odfUd--vOb8-XXr54AYTmmYIAw0rcTw/Redgate-SSC-setup.png?psid=1
and I'm putting the redgate.ssc file here:
https://public.blu.livefilestore.com/y1pcP1VyLTTS6h-ZtdkfST0OXc7wtD1q1bWnAz64ee304tkXh0xnWV73uIQsva89_wdTfB1LWNMGaEsmzLsZWqsGQ/redgate%20ssc.PNG?psid=1
I've tried checking the entire tree out of source control so it had modify permissions as well. What am I missing? -
Thanks for your post. Which folder are you linking to? Based on your screenshots it should be the "CreateScripts" one so that the Functions, Security etc. folders are immediate children.
The other thing is that your redgate.ssc (we usually case it "RedGate.ssc" but that shouldn't matter) still has a blue "+" next to it, which I think indicates you've not actually committed it into the repository yet. You'd need to do that before linking. -
Yes, I'm linking to the Create Scripts folder as the root. I did not check the file in, so I'll do that and fix the case to see where that takes me. Thanks for the suggestions!
-
Thanks, I didn't realize the file also had to be checked-in, but that did it. Thanks for your help.
-
Adding an empty RedGate.ssc in the root folder worked for me
Add comment
Please sign in to leave a comment.