System.OutOfMemoryException

gleatherman

When I try to get latest or commit SCHEMA ONLY, no static data, I get System.OutOfMemoryException.
I am having similar issues with SQL Doc and DLM Dashboard. SQL Compare and even Data Compare seem to work fine. Any suggestions? I have 64-bit Windows 10 with updates and 32 gig of memory.

Mike U

Are you using migration scripts?

gleatherman

I have just installed the products and added the database. I'm not using any other functionality yet.

gleatherman

If you are in the U.K., I know you probably want to leave work about now. This can wait until tomorrow. Cheers.

Mike U

We have a US support team who are closer to your time-zone - I'll ask them to take a look.

Sergio R

Hi,

It appears that the tools you are having trouble with are the 32 bit ones.
SQL Compare and SQL Data Compare are 64 bit.

Even though SQL Doc is a 32 bit application, the command line tool is 64 bit, so a workaround in for your issue would be to use it:
http://documentation.red-gate.com/display/SDOC3/Using+the+command+line

SQL Source Control is an SSMS plugin (which is 32 bit), however there a few things you could do, please see the following document:
http://documentation.red-gate.com/display/SOC5/System.OutOfMemoryException
(I suggest trying using the Large Address Aware utility on SSMS as that will allow it to use more RAM).

Thank you,

gleatherman

This did not help the version of SSMS I was on, but I ran that same tool on SSMS 17 and it started working. Thanks!