SQL Source Control 4

Changing the location of the working base

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 4\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

  1. 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).
  2. Close Management Studio.
  3. Go to the SQL Source Control config files folder. By default, this is located at %localappdata%\Red Gate\SQL Source Control 4
  4. Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.

  5. 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.

  6. Save and close the file.
  7. 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.
Any databases you link in the future will locate their working folders at the path you specified in the config file.

Didn't find what you were looking for?