Embedded Resource limitation on large databases

Forum for users of SQL Packager database archive utility

Embedded Resource limitation on large databases

Postby paul » Thu Feb 21, 2008 4:03 am

SQL Packager 5.4

My question concerns the 50MB limitation on package sizes when packaging large databases. This causes dlls to be created to store the extra data.

This was noted in this forum post: http://www.red-gate.com/messageboard/vi ... ght=store1

Is there a supported or well-accepted workaround for this involving modifications to the C# templates maybe? Something that may involve pre-compressing the data prior to package insertion?

We already have a database versioning\\release process in place and stumbled across this problem today. Our process revolves around the one package exe that's generated and so the additional dlls involved with large db's are a problem.

Anyway, just curious as to any solutions that have presented themselves regarding the subject.

Thanks for any help,

Posts: 10
Joined: Thu Jan 19, 2006 3:55 pm

Postby chris.buckingham » Tue Feb 26, 2008 12:07 pm

I'm sorry to say that there is an arbitrary limit on the AppDomain class that Microsoft set which is out of our control - therefore there isn't a workaround for the 50MB limit.
Chris Buckingham
Red-Gate support
Posts: 56
Joined: Mon Jul 30, 2007 12:39 pm

Return to SQL Packager Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests