How can we help you today? How can we help you today?

System.OutOfMemoryException

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.
gleatherman
0

Comments

6 comments

  • Mike U
    Are you using migration scripts?
    Mike U
    0
  • gleatherman
    I have just installed the products and added the database. I'm not using any other functionality yet.
    gleatherman
    0
  • gleatherman
    If you are in the U.K., I know you probably want to leave work about now. This can wait until tomorrow. Cheers.
    gleatherman
    0
  • Mike U
    We have a US support team who are closer to your time-zone - I'll ask them to take a look.
    Mike U
    0
  • 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,
    Sergio R
    0
  • 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!
    gleatherman
    0

Add comment

Please sign in to leave a comment.