"The path must be an empty folder" error

jamal

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?

David Atkinson

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

jamal

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?

James B

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.

jamal

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!

jamal

Thanks, I didn't realize the file also had to be checked-in, but that did it. Thanks for your help.

rmbuda

Adding an empty RedGate.ssc in the root folder worked for me