In our main database we've added a computed column for file size (defined as IsNull(DATALENGTH(c_binary),0) PERSISTED NOT NULL).
This change obviously takes quite some time when run on a database with a lot of binaries. When I ran the script manually on a database of about 25GB (most of it binaries) I had to wait about 25 minutes for the size columns to drop and be recreated with the new column.
When using Packager Plus to create an .exe to do these changes for me, I first have to wait 25 minutes (as per the pre process script), and then the installer starts changing the primary keys on my tables. This takes forever, and the database grows extremely much. After an hour and half my 25GB database was 50 GB, and the server disk was full.
I've set in the XML file that no data should be added or dropped, and I guess I'm doing something seriously wrong, or this software is totally useless.
Regards,
Anders
|
Major problem with packager plus
Posted - 10/20/2009 : 15:38:20
