We just use a simple version number stored in a table in the db. We read it on upgrade using a custom action scheduled before CostInitialize and then only components which are greater than that version number are installed based on a component condition like what's below.
<Condition><![CDATA[DATABASEOPTIONS="upgrade"]]> AND <![CDATA[DB_VERSION<3]]></Condition> --3 is the version this particular component upgrades to Dana On Thu, Sep 25, 2008 at 2:51 AM, Michael Osmond <[EMAIL PROTECTED]>wrote: > Hi Eitan, > > I also would be interested in knowing what people are doing here. > > We do something akin to yours, but have put the logic in the database > itself. We build an "update package" which is a set of database > changes. Each update package is given a GUID and as we apply the change > package we write the GUID to a table in the database, each step in the > update package must test for the existance of its GUID in the table. > > So far I have not found anything in MSI or WIX that allows you to really > do what you have said here. In part I think it is because a database is > something fundimentally different to a dll or exe. You can't just > replace it. > > But I would be very interested in being told I am wrong. > > Michael > > -----Original Message----- > From: Eitan Behar [mailto:[EMAIL PROTECTED] > Sent: Thursday, 25 September 2008 4:42 PM > To: General discussion for Windows Installer XML toolset. > Subject: [WiX-users] SQL scripts and Upgrades > > Hi, > > I have a big fat setup with several baseline SQL scripts, and after it's > released, I get delta SQL scripts that fix the released database. > > The scenario is as follows: > > When doing a first installation, I do the baseline (v0), plus all the > deltas (i.e. v1, v2, v3) > > If doing an upgrade, I do check which version is installed and run only > the corresponding delta (i.e. if v1 is installed, run v2, and v3). I do > all this process using custom actions. > > I wonder if there is a better way to do this. Can I set a condition that > does not reinstall a particular component if it's already installed? > > Thanks, > > Eitan > ------------------------------------------------------------------------ > - > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge Build the coolest Linux based applications with Moblin SDK & > win great prizes Grand prize is a trip for two to an Open Source event > anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------- > This SF.Net email is sponsored by the Moblin Your Move Developer's > challenge > Build the coolest Linux based applications with Moblin SDK & win great > prizes > Grand prize is a trip for two to an Open Source event anywhere in the world > http://moblin-contest.org/redirect.php?banner_id=100&url=/ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
