You can only change the location of the working base in SQL Source Control 3.3 and later.
The working base is a local copy of the database at the last time you ran a commit or a get latest. For more information, see How SQL Source Control works behind the scenes.
By default, the working base for each linked database is saved in %localappdata%\Red Gate\SQL Source Control 3\WorkingBases. You can change this by editing a config file.
We don't recommend changing the location of the working base unless the default location is causing problems.
Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.
EngineOptions version line, add
where C:\Temp\ is the path you want to move the working base to.
Ignoring any comments (indicated with <!->), the final file should look like this:
<EngineOptions version="3" type="EngineOptions"> <WorkingPath>C:\Temp\</WorkingPath> </EngineOptions>
The example above doesn't include any extra lines you may have included to configure other options. For example, you may have included additional lines to set up change logging.