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

Skip to end of metadata
Go to start of metadata

By default, SQL Source Control polls the database for changes every 60 seconds. You can change or disable this by editing a config file.

  1. Go to the SQL Source Control config files folder. By default, this is located at %localappdata%\Red Gate\SQL Source Control 3
  2. Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.

  3. Inside the <EngineOptions> tags, add:

    This sets polling interval time to 30,000 milliseconds (30 seconds). You can change the value in the <DefaultTraceMinimumInterQueryTimeInMillis> tags to the interval you want.

  4. Save and close the file.

SQL Source Control will poll the database at the interval you specified.

Disabling automatic polling

Disabling polling will stop SQL Source Control automatically marking objects that have uncommitted changes with blue change indicators in the Object Explorer. You can still see the list of objects with uncommitted changes in the Commit tab in SQL Source Control.

  1. Go to the SQL Source Control config files folder. By default, this is located at %localappdata%\Red Gate\SQL Source Control 3
  2. Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.

  3. Inside the <EngineOptions> tags, add:

    This will disable the automatic polling. To re-enable polling, delete the <PollingEnabled>False</PollingEnabled> line.

  • No labels