Red Gate forums :: View topic - Package not getting created cleanly
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

Package not getting created cleanly

Search in SQL Packager Previous Versions forum
Post new topic   This topic is locked: you cannot edit posts or make replies.
Jump to:  
Author Message
jbrodin



Joined: 24 Feb 2005
Posts: 3

PostPosted: Tue Apr 19, 2005 6:53 pm    Post subject: Package not getting created cleanly Reply with quote

Most of the time I'm getting a single .exe when I create a package. However for several of our databases I get several files when I try to package:
<packagename>.exe
<packagename>store1.dll
<packagename>store2.dll
<packagename>store3.dll

The .exe file is small but all the .dll files can be very large (i'm guessing this is the data). The other issue is that the package creation is MUCH slower when it runs when this happens compared to a single .exe file. I believe database size is a factor since several of our databases can be fairly large -- 200+ megs.

I am running SQL Packager 1.1.2.5 which is the latest current version but I experienced this in the last version as well.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6641

PostPosted: Fri May 13, 2005 5:59 pm    Post subject: Reply with quote

Hello,

There is a bit of a limitation in Microsoft .net in how large an embedded resource can be in a .NET assembly. This affects SQL Packager because this is how the scripts are saved into the executable. The maximum size is 50MB, so any package larger than that will start producing dlls that are just full of data, but the main executable will remain small.

I can't say for sure why the package would run any slower, except that you're possibly running low on memory. Hopefully it's something as simple as that.
Back to top
View user's profile Send private message
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies. 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