SQL Source Control 3

Changing the number of revisions shown in the History dialog box

The number of revisions shown can only be changed in SQL Source Control 3.5.1 and later.

By default, the History dialog box shows all the revisions made to the selected database. You can change the number of revisions shown by editing a config file.

If the History dialog box is slow to load, limiting the number of revisions shown may speed it up.

To do this:

  1. Close Management Studio.
  2. Go to the SQL Source Control config files folder: %localappdata%\Red Gate\SQL Source Control 3
  3. Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.

  4. Inside the <EngineOptions> tags, add:

    <MaxHistoryItems>200</MaxHistoryItems>

    The file is case sensitive. Don't change the capitalization of the text.

    This will show the 200 most recent revisions in source control; older revisions won't be shown. You can change the value in the <MaxHistoryItems> tags to the number you want. 

    To show all revisions, set the value to 0.

    Ignoring any comments (indicated with <!->), the final file should look like this:

    <EngineOptions version="3" type="EngineOptions">
    	<MaxHistoryItems>100</MaxHistoryItems>
    </EngineOptions>

    The example above doesn't include any extra lines you may have included. For example, you may have included additional lines to set up change logging.

  5. Save the file.

The History dialog box will show the number of revisions you specified.


Didn't find what you were looking for?