These pages cover SQL Source Control 3. Help for older versions is also available.

SQL Source Control includes an optional beta version of the improved migration script feature. We'd love to hear what you think.

Skip to end of metadata
Go to start of metadata
Icon

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 the technical overview.

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.

Icon

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, first unlink it in the Setup tab. This removes the existing working folder for the database (a new one will be created later).
  2. Close SQL Server Management Studio.
  3. Go to the SQL Source Control config files folder. By default, this is located at %localappdata%\Red Gate\SQL Source Control 3
  4. Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.

  5. Below the EngineOptions version line, 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:

    Icon

    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.
Icon
Any databases you link in the future will locate their working folders at the path you specified in the config file.
  • No labels