Refresh in commit and get latest tabs takes a long time
Published 08 October 2018
By default, SQL Source Control automatically refreshes the list of changes in the commit and get latest tabs when the focus on the tab is lost.
In SQL Source Control 6.3.2 and later, the automatic refresh behavior can be disabled.
How to disable automatic refresh in the commit and get latest tabs
- Open %localappdata% in your File Explorer
- Navigate to the folder Red Gate\SQL Source Control 6
- Open the file RedGate_SQLSourceControl_CommonUI_UIOptions.xml
- Add a new tag inside the root UIOptions
<DisableAutoRefresh>True</DisableAutoRefresh> - Save the file
- Restart SSMS
Known Limitations
- The list of changes always refreshes automatically when switching to a different database in the Object Explorer
- The list of changes always get refreshed after a commit or get latest