Unable to find a RedGate.ssc file at the database location specified

tso617

I am following instructions left by a former employee on using SQL Compare where the source is a local copy I just cloned from Git and the target is a SQL Server database.

I can connect to the SQL Server DB OK.

When I specify the source control system as Git and provide the path to the base for that database I receive an error when I click the Link button.

"Database location isn't valid" > "Unable to find a RedGate.ssc file at the database location specified"

I don't have access to the former employees laptop and am wondering if there is some trick I am missing, for example, I can confirm the the location of git.exe is in my windows PATH variable (at the top now).

The only thing I can think is that the former employee had this file stored locally but never pushed it into Git. IF this is the case, what does this file do/contain and how to I create it please? Will it work for other employees that also have a licence to use SQL Compare please?

DanC

Hi @tso617

Thanks for reaching out and sorry that you're having trouble with SQL Source Control. When initially setting up a SQL Source Control project, you would need to link to an empty folder because SQL Source Control creates a specific folder structure that helps maintains the structure of the database and allows for it to be compared. A file called RedGate.ssc gets created and if that file doesn't exist in a non-empty folder it will throw this error message. 
 
E.g

 
I hope this helps. Please let me know if you have any further questions. 

tso617

Thanks, but I have zero experience of using any Redgate products. I suspect we'll need to ditch them and go back to writing manual scripts. :-(

DanC

Hi @tso617

I would advise looking at the Redgate University here which will give you demos on how to use the tool: https://www.red-gate.com/hub/university/?_ga=2.130612815.1791409911.1664185189-1040316704.1654531237

The docs are also great resource: https://documentation.red-gate.com/home?_ga=2.53981549.497014671.1572435081-385040425.1572277860