Comparing big Databases error ( resolved )

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.

RinDman July 17, 2017 08:38

Comments

2 comments

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!

Anu D July 20, 2017 10:19

0
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

RinDman July 20, 2017 10:50

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Comparing big Databases error ( resolved )

Comments

Add comment