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.
Editing the config file
- If you want to move the working folder of a database you've already linked, first unlink it in the Setup tab. This removes the existing working folder for the database (a new one will be created later).
- Close SQL Server 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 your working base to be located.
Ignoring any comments (indicated with <!->), the final file should look like this:
- 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.