Options

Getting System.OutOfMemoryException error (in the log file)

gvarol@corelogic.comgvarol@corelogic.com Posts: 90 Bronze 3
edited March 17, 2011 12:22PM in SQL Compare Previous Versions
[Post text removed on request of the user]
· Share on Twitter

Comments

  • Options
    James BJames B Posts: 1,124 Silver 4
    Can you check your disk space usage during the comparison? Is it possible you're running low on space on the C: drive?

    Does this problem only occur with one database, or any?
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • Options
    gvarol@corelogic.comgvarol@corelogic.com Posts: 90 Bronze 3
    [Post text removed on request of the user]
    · Share on Twitter
  • Options
    James BJames B Posts: 1,124 Silver 4
    Hmm, I guess it could be the large number of partitions that are affecting it; I can't say I've tried it on that particular configuration of database. One to have a look at in the office tomorrow. There's an option to ignore filegroups and partition schemes, and I think it's on by default, so that may not make any difference. And of course if that's something you want to compare and sync you don't really want to turn it off!
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
  • Options
    gvarol@corelogic.comgvarol@corelogic.com Posts: 90 Bronze 3
    [Post text removed on request of the user]
    · Share on Twitter
  • Options
    James BJames B Posts: 1,124 Silver 4
    Sorry for my delay in replying.
    I'm not sure a snapshot would correctly define all the partitions - could you instead run a create script for the DB and send that?

    Please send it to support@red-gate.com quoting F0045754 in the subject line.
    Systems Software Engineer

    Redgate Software

    · Share on Twitter
Sign In or Register to comment.