This option can now be easily changed in the new Setup tab released on Frequent Updates. It will be added to a later version of SQL Source Control.

If you don't want to install Frequent Updates, follow the instructions below.

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:

    <DefaultTraceMinimumInterQueryTimeInMillis>30000</DefaultTraceMinimumInterQueryTimeInMillis>

    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

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:

    <PollingEnabled>False</PollingEnabled>

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