running out of memory...?

dippies

Hi all,
I'm running sql compare 8 and I only get to the 72% mark then it all stops, have left it for hours to run but I just cannot get pas the mark.
running windows 7 (32)
4gb memory (1 reserved, 1.5 in use, 700 standby, 800 free)
any help would be great

Chris Auckland

Thanks for your post.

It sounds like SQL compare might actually be running out of memory.

Could you check how much memory the SQL Compare process is consuming? If it's over 1.5 GB, then as SQL Compare is a 32bit application and the process is therefore limited to 2GB of mem, it could be exceeding the limit.

This would mean that you have an impressively large schema, as it's pretty rare for a schema to be so large it causes SQL Compare to run OOM.

If this is the issue, then you could try a special 64bit build we have, that isn't limited to 2GB.
<ftp://support.red-gate.com/patches/SQL_Compare/SQL_Compare_8.50_x64.zip&gt;

Please note that this version has not been fully tested, so the normal caveats apply.

I hope this helps.