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.
Editing the config file
- If you want to move the working folder of a database you've already linked, unlink it in the Setup tab. This removes the existing working folder for the database (a new one will be created later).
- Close Management Studio.
- Go to the SQL Source Control config files folder. By default, this is located at %localappdata%\Red Gate\SQL Source Control 3
Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.
EngineOptions versionline, 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:
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.
- Save and close the file.
- If you unlinked a database in step 1, open SSMS and relink it in the SQL Source Control Setup tab. This creates a new working folder for this database in the location you specified in step 6.