These pages cover SQL Source Control 3. Documentation 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

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

Changing the polling interval

  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.

    Icon

    This file may not exist in some installations. If it doesn't exist in your installation:

    1. Create an .xml file named RedGate_SQLSourceControl_Engine_EngineOptions.xml in the folder.
    2. Open the file in a text editor and paste this into it:

  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.

    Icon

    This file may not exist in some installations. If it doesn't exist in your installation:

    1. Create an .xml file named RedGate_SQLSourceControl_Engine_EngineOptions.xml in the folder.
    2. Open the file in a text editor and paste this into it:

  3. Inside the <EngineOptions> tags, add:

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

  • No labels