System.OutOfMemoryException

linuxinducteelinuxinductee Posts: 5
edited March 22, 2007 5:33PM in SQL Packager Previous Versions
We've purchased the software suite with full API functionality.

Our first run trying to copy a database using SQL Packager has not been so successful.

After having disk space issues and no key errors, I finally got the process running against a 90 gb database only to get a System.OutOfMemoryException. Considering this workstation has 2 gb RAM and nothing else is running on it, I'd like to see how this software is actually usable.

Operating system: WinXP pro ( 5.1.2600 )
Sql Packager: 5.3.0.80
Database: Sql Server Enterprise 2005 ( on Windows 2003 Server )

To solve the first two errors, I created variable pointing to a network drive ( gig card ) and excluded the table with the missing key ( proprietary database ). Oh, and there was a permission snafu for creating a assembly object that I fixed.

If I could get past this memory problem, this software might actually have value. Thanks for your time.

Also, is there a setting to enable the job to bypass and report errors, while continuing to do the job of moving schema and data?

Comments

  • Hey, is this the support feature? No acknowledgement or anything indicating someone is actually looking at user problems?

    :?:
  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi,

    Sorry, the support process needs to be clarified. The forums aren't 'official' support. That's not to say you won't get a solid answer. But if you want a formally tracked and logged support issue, the route to go is by email: support@red-gate.com.

    Packager's scripts are designed to rollback on error. You can disable transactions in the options, but this might leave you with a partial sync. I don't recommend it.

    OutOfMemoryExceptions are thrown on low disk space as well as a lack of physical memory. Setting the RGTEMP environment variable in a console, then running Packager, can get it to use a bigger hard disk. The default location for temporary storage is in your personal profile (c:\documents and settings) SET RGTEMP=d:\temp will get packager to use d:\temp instead.

    Hopefully this sorts the problems for you.
Sign In or Register to comment.