Change how many revisions are shown in the History dialog box
Published 16 July 2015
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 6
Open RedGate_SQLSourceControl_Engine_EngineOptions.xml in a text editor.
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
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.