Best way I've found to create SQL installs is to ensure all scripts are idempotent. You want to be able to repair your MSI and have the scripts that don't need to do anything not do anything and the scripts that find stuff missing to recreate the missing stuff. Then, when you release next update, you can add additional scripts that apply additional behavior.
If you have really complex stuff to verify, one way to create "mostly idempotent" scripts is to create a "version" table somewhere. Then the scripts can verify if their version is missing from the version table and then they run before finally updating the version table. On Mon, Jan 3, 2011 at 5:18 PM, wix user <wixuser...@gmail.com> wrote: > Hi Rob, > > Do you mean a different component for update than the installation? If yes, > we need to skip the installation part of it during the update based on some > check for already installed db. How to handle these conditions? Using > Transient components? > How failures are handled? > Do you have any example are links to any document? > Thanks > On Sat, Jan 1, 2011 at 5:02 PM, Rob Mensching <r...@robmensching.com> > wrote: > > > You can run SQL Scripts that update your SQL databases. > > > > On Thu, Dec 30, 2010 at 11:55 AM, wix user <wixuser...@gmail.com> wrote: > > > > > Hi all, > > > > > > I would like to know about updating sql databases using wix. > > > Does wix handles this scenarios using minor updates? > > > Any information/links in this area is appreciated. > > > > > > Thanks > > > > > > > > > ------------------------------------------------------------------------------ > > > Learn how Oracle Real Application Clusters (RAC) One Node allows > > customers > > > to consolidate database storage, standardize their database > environment, > > > and, > > > should the need arise, upgrade to a full multi-node Oracle RAC database > > > without downtime or disruption > > > http://p.sf.net/sfu/oracle-sfdevnl > > > _______________________________________________ > > > WiX-users mailing list > > > WiX-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > > > > > > -- > > virtually, Rob Mensching - http://RobMensching.com<http://robmensching.com/> > <http://robmensching.com/>LLC > > > > > ------------------------------------------------------------------------------ > > Learn how Oracle Real Application Clusters (RAC) One Node allows > customers > > to consolidate database storage, standardize their database environment, > > and, > > should the need arise, upgrade to a full multi-node Oracle RAC database > > without downtime or disruption > > http://p.sf.net/sfu/oracle-sfdevnl > > _______________________________________________ > > WiX-users mailing list > > WiX-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > ------------------------------------------------------------------------------ > Learn how Oracle Real Application Clusters (RAC) One Node allows customers > to consolidate database storage, standardize their database environment, > and, > should the need arise, upgrade to a full multi-node Oracle RAC database > without downtime or disruption > http://p.sf.net/sfu/oracle-sfdevnl > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
