Changing the number of revisions shown in the History dialog box
Published 02 October 2013
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.
To do this:
- Close Management Studio.
- Go to the SQL Source Control config files folder: %localappdata%\Red Gate\SQL Source Control 3
Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.
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 to0
.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.
- Save the file.
The History dialog box will show the number of revisions you specified.