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

Icon
If you disable polling, SQL Source Control won't mark 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 SQL Source Control Commit tab.
  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