I am sorry that you are having issues when using SQL Source Control.
We have introduced caching in the latest versions of SQL Source Control, in some cases and since the tool runs within SSMS.exe which a 32bit process and therefore limited in the amount of RAM it can access this can cause out of memory exceptions.
To avoid this issue you should disable caching by following these steps:
2 - Update to the latest Frequent Update (version 4.2.1)
3 - After updating you will need to edit the following file:
%localappdata%Red GateSQL Source Control 4RedGate_SQLSourceControl_Engine_EngineOptions.xml
and add the following:
crimdon
Posts: 54 Bronze 3
Comments
I am sorry that you are having issues when using SQL Source Control.
We have introduced caching in the latest versions of SQL Source Control, in some cases and since the tool runs within SSMS.exe which a 32bit process and therefore limited in the amount of RAM it can access this can cause out of memory exceptions.
To avoid this issue you should disable caching by following these steps:
1 - You need to have Frequent Updates turned on
http://documentation.red-gate.com/displ ... nt+Updates
2 - Update to the latest Frequent Update (version 4.2.1)
3 - After updating you will need to edit the following file:
%localappdata%Red GateSQL Source Control 4RedGate_SQLSourceControl_Engine_EngineOptions.xml
and add the following:
<EngineOptions version="3" type="EngineOptions">
<DisableCaching>True</DisableCaching>
</EngineOptions>
(Please note that %localappdata% usually corresponds to `C:Users(username under which SSMS runs - usually the logged in user)AppDataLocal)
Thank you,
Product Support Engineer
Redgate Software Ltd
Please see our Help Center for detailed guides on how to use our tools