Comparing big Databases error ( resolved )
RinDman
Posts: 2
Hello,
I have some issues when I try to compare 2 big databases.
I have only 8 Gb left on my C: and when I try to compare, SQL Compare is using the paging file and stop the compare when the C: is full. The RAM is still free ...
Any tips to fix that ?
Thx.
I have some issues when I try to compare 2 big databases.
I have only 8 Gb left on my C: and when I try to compare, SQL Compare is using the paging file and stop the compare when the C: is full. The RAM is still free ...
Any tips to fix that ?
Thx.
Tagged:
Comments
You can ask SQL Compare to point to other drive by setting environmen variable called RGTemp.
More about how to set it: https://documentation.red-gate.com/display/SDC12/Troubleshooting+System.OutOfMemoryException+during+comparison
I know above article is for SQL Data Compare but it works for all Red gate products.
Hope this helps!
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
thanks for the answer, next time I'll try that, clearly the proper way to relax the swap usage.
For now I've fixed my problem by balancing Windows' swap between my 2 partitions.
Regards