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.
Below the EngineOptions version
line, add
<WorkingPath>C:\Temp\</WorkingPath> |
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. |
Any databases you link in the future will locate their working folders at the path you specified in the config file. |