Red Gate forums :: View topic - System.OutOfMemoryException
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager Previous Versions
SQL Packager Previous Versions forum

System.OutOfMemoryException

Search in SQL Packager Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
linuxinductee



Joined: 21 Mar 2007
Posts: 3

PostPosted: Wed Mar 21, 2007 8:16 pm    Post subject: System.OutOfMemoryException Reply with quote

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?
Back to top
View user's profile Send private message
linuxinductee



Joined: 21 Mar 2007
Posts: 3

PostPosted: Thu Mar 22, 2007 7:24 pm    Post subject: Reply with quote

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

Question
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6673

PostPosted: Thu Mar 22, 2007 10:33 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group