Options
Unable to find a RedGate.ssc file at the database location specified
tso617
Posts: 2 New member
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?
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?
Tagged:
Answers
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.
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
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
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?