"The path must be an empty folder" error

jamal · November 30, 2011 3:07PM

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 · December 2, 2011 4:43PM

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 · December 8, 2011 2:50PM

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 · December 9, 2011 4:50AM

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 · December 9, 2011 1:40PM

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 · December 9, 2011 1:58PM

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

rmbuda · May 27, 2019 12:49AM

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

"The path must be an empty folder" error

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk

&quot;The path must be an empty folder&quot; error

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk

"The path must be an empty folder" error