You need to get the Component with your SQL content to be repaired. I expect the log file is saying the Component is being skipped because it is already up to date. You may need to explicitly set the ADDLOCAL property to force your Component to install (IIRC).
On Wed, Mar 23, 2011 at 6:16 AM, Tobberoth <tobber...@gmail.com> wrote: > Hello, > > I'm currently working on a system to deliver updates to a web application > as > windows installers, both major and minor upgrades. I've gotten major > upgrades to work like I want them, but I can't seem to wrap my head around > minor upgrades. > > I've made a .msp which correctly updates files, but I also need it to run > sql scripts on a database. While I've gotten this to work in .msis, it > seems > to be ignored in my .msps. I've added a User element, a Database element > and > a SqlString element in the "new" installer, and I have a componentref to > the > component with the SqlString in the patch family of the patch file. When > using repair on the .msp, it works fine, but the sqlstring isn't run on the > database. Looking at the log, the sql component isn't even mentioned. The > feature containing the sql component is published, but that's about it. > > I've tried adding a <CreateFolder/> element to the sql component which made > AllowRemoval non-usable, but it had no effect otherwise. Both > ExecuteOnInstall and ExecuteOnReinstall is set to "yes". > > What do I need to do to have the sql run properly? > > Regards > /Tobberoth > > ------------------------------------------------------------------------------ > Enable your software for Intel(R) Active Management Technology to meet the > growing manageability and security demands of your customers. Businesses > are taking advantage of Intel(R) vPro (TM) technology - will your software > be a part of the solution? Download the Intel(R) Manageability Checker > today! http://p.sf.net/sfu/intel-dev2devmar > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > -- virtually, Rob Mensching - http://RobMensching.com LLC ------------------------------------------------------------------------------ Enable your software for Intel(R) Active Management Technology to meet the growing manageability and security demands of your customers. Businesses are taking advantage of Intel(R) vPro (TM) technology - will your software be a part of the solution? Download the Intel(R) Manageability Checker today! http://p.sf.net/sfu/intel-dev2devmar _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
