Murray I know there is some stuff if you search through the history of this mailing list. I don't know of any tutorials or other info, but that doesn't mean there isn't any.
First what runs in an upgrade is really going to depend on if you are doing an MSI Major Upgrade or Minor Upgrade. If it's a minor upgrade then you can use the ExecuteOnInstall (for install) and ExecuteOnReinstall (for upgrade) flags. If it is a major upgrade then you need to put the scripts into different components (one for install), a different one for upgrade. You then need to condition the components to run when you need. For you question about different versions - then I would say, group them into components and put the conditions on components. An alternate, what we use is that upgrades are actually conditioned in the SQLScripts themselves, based on versions (and alternately GUIDs) being written into a table in the database, so all I rely on WIX for is to execute the install scripts the first time, and upgrade scripts from then on. Michael -----Original Message----- From: Murray Hipper [mailto:mhip...@snowdengroup.com] Sent: Tuesday, 5 May 2009 3:04 PM To: wix-users@lists.sourceforge.net Subject: [WiX-users] Upgrading SQL Server in Wix Hi Guys, I wanted to ask the community for any best practices or methods used with the upgrading of SQL Databases through WIX. The install step is fine and pretty straight forward, the upgrade process is messy and I am unsure what scripts will run and when. I did a quick search but wasn't able to find too much regarding the issue. Does anyone have any links to blogs or similar resources on people presenting solutions to the SQL Server upgrade process using wix? I obviously am encountering issues where I will want it to run certain scripts depending on certain versions. Does this mean I can put a Condition on the component such as UPGRADEDVERSION <= 1.1.10.0 or something? Thanks, Murray This e-mail and any attachments to it (the "Communication") are confidential and are for the use only of the intended recipient. The Communication may contain copyright material of the Snowden Group ("Snowden"), or any of its related entities or of third parties. If you are not the intended recipient of the Communication, please notify the sender immediately by return e-mail, delete the Communication, and do not copy, print, retransmit, disclose, store or act in reliance on the Communication. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Snowden. Although virus protection devices and procedures are in place, Snowden does not guarantee the integrity of the Communication, or that it is free from errors, viruses or interference. Snowden advises email recipients to carry out their own virus checks before opening any attachment. Please note that the main telephone number for the Snowden Perth office has changed to +61 8 9213 9213. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your production scanning environment may not be a perfect world - but thanks to Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700 Series Scanner you'll get full speed at 300 dpi even with all image processing features enabled. http://p.sf.net/sfu/kodak-com _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
