[wix-users] Modify Schema

[Rob Mensching]

None of that should be necessary. Any modern WiX Toolset uses the large sizes.

_____________________________________________________________
 Short replies here. Complete answers over there: http://www.firegiant.com/


-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Ronny Eriksson
Sent: Monday, August 22, 2016 9:58 AM
To: WiX Toolset Users Mailing List <wix-users at lists.wixtoolset.org>
Subject: Re: [wix-users] Modify Schema

I think u missed this part of that page u referred to ...

https://msdn.microsoft.com/en-us/library/windows/desktop/aa367767(v=vs.85).aspx



To increase the limit of a database column

1. Export the table to an .idt file. For details, see Msidb.exe<https://msdn.microsoft.com/en-us/library/windows/desktop/aa370083(v=vs.85).aspx>, Export Files<https://msdn.microsoft.com/en-us/library/windows/desktop/aa368570(v=vs.85).aspx>, and Importing and Exporting<https://msdn.microsoft.com/en-us/library/windows/desktop/aa369216(v=vs.85).aspx>.

2. Edit the .idt file to change the column type from i2 to i4, or from I2 to I4.

3. Export the _Validation table to an .idt file.

4. Edit the .idt file to change the values in the MaxValue column of the _Validation table to accommodate the increased column widths.

5. Import the .idt files back into the database.

Note that transforms and patches cannot be created between two packages with different column types.



Ronny Eriksson



-----Original Message-----
From: wix-users [mailto:wix-users-bounces at lists.wixtoolset.org] On Behalf Of Neil Hayes
Sent: den 22 augusti 2016 13:19
To: wix-users at lists.wixtoolset.org
Subject: [wix-users] Modify Schema



I'm authoring a large package, more than 32767 files. In order to do that I have to ensure the msi schema supports this.



Looking at this link:



https://msdn.microsoft.com/en-us/library/windows/desktop/aa367767(v=vs.85).aspx



Quote :







If your Windows Installer package contains more than 32767 files, you must change the schema of the database to increase the limit of the following columns:

*         The Sequence column of the File table<https://msdn.microsoft.com/en-us/library/windows/desktop/aa368596(v=vs.85).aspx>.

*         The LastSequence column of the Media table<https://msdn.microsoft.com/en-us/library/windows/desktop/aa369801(v=vs.85).aspx>.

*         The Sequence column of the Patch table<https://msdn.microsoft.com/en-us/library/windows/desktop/aa370737(v=vs.85).aspx>.

If I build a test install I can look at the _Validation table to check the values.



Looking at the File table and the Sequence column this is set to 2147483647



Looking at the Media Table and the LastSequence Column this is set to 2147483647 The Patch table entries are missing.

I then looked in darice.cub but only find a an attributes value under the patch section in the _ReservedBits table.

Questions:



Which file does WiX use for the msi schema?



Where do I put the Sequence column value for the Patch table? ( I'd have to change the column type for a small integer.)



Do we have a WiX document or other on how to do this?



Is there something else I'm not aware of that should be done?







The plan is to roll out an RTM version



Apply hot Fixes for 3 months



Service pack at every 3 months



Apply hot Fixes for next 3 months.....and so on.



Regards



Neil Hayes





____________________________________________________________________

WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/

____________________________________________________________________
WiX Toolset Users Mailing List provided by FireGiant http://www.firegiant.com/