Comparing big Databases error ( resolved )

RinDman

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.

Anu D

Hi RinDman,

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!

RinDman

Hi,

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