Hi John, My apologies for the late reply, integration testing is keeping me busy.
Chris is correct; we just want to leverage the capabilities of the MSI to get the database installed. The MSI appears to be doing a nice job - as long as you want to install only a single database. I am open to alternatives. What do you mean with "modify the maintenance process"? I like the batch script option you suggest. For the completeness of discussion; Chris also mentioned off-line that one could create a fake MSI that doesn't actually install any components or publish any information; I also like this option. Thank you, Daniel On Wed, Jul 23, 2008 at 8:17 PM, John Nannenga <[EMAIL PROTECTED]>wrote: > Any particular reason they do this? (I'm not bashing folks or anything > like that; I'm simply genuinely curious what the advantage would be in doing > this) > > > As Chris mentioned, you could modify the maintenance process to support > your needs, leaving the product installed. > > If that option doesn't appeal to you and you simply want your ideal way of > "the MSI would un-install itself after it finished creating the database", > here's a rather interesting option: > > Presuming your SQL installation routine doesn't use a rollback script... > you could, force failure after your SQL installation is complete (which > would then 'rollback the installation' and leave your DB stuff intact while > not leaving the MSI [shim] installed). Modify the UI end dialogs > accordingly. (though the MSI error code returned would still be failure, > but if nothing's looking at that, what the heck, right?) > > Or if that's too corny, you could wrap the MSI; either an external UI > handler [a bit of work] or simply a batch script [or simply a utility] to > perform the installation, then when completed, perform a silent > un-installation. > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto: > [EMAIL PROTECTED] On Behalf Of Daniel Zak > Sent: Wednesday, July 23, 2008 8:00 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Multiple Installs without Un-Install? > > I spoke to three different teams in our organization and they all use an > MSI > to install a database. I decided to try this as an alternative to the DOS > batch script I used in the previous version of our software. > > > On Wed, Jul 23, 2008 at 10:14 AM, John Nannenga < > [EMAIL PROTECTED]> > wrote: > > > > Ideally, the MSI would un-install itself after it finished creating the > > > database. > > > > This might be off topic, but curiosity got the best of me; given that to > be > > the case, why would this be in an MSI at all? > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto: > > [EMAIL PROTECTED] On Behalf Of Daniel Zak > > Sent: Wednesday, July 23, 2008 12:05 PM > > To: [EMAIL PROTECTED]; General discussion for Windows > > Installer XML toolset. > > Subject: Re: [WiX-users] Multiple Installs without Un-Install? > > > > The user wants to have the ability to install a database from any remote > > machine. Also, additional databases would be installed at some other > point > > in time (e.g. perhaps 3 months later the user decides they need a second > > database). > > > > Ideally, the MSI would un-install itself after it finished creating the > > database. > > Cheers, > > Daniel > > > > On Wed, Jul 23, 2008 at 6:19 AM, Christopher Painter < > > [EMAIL PROTECTED]> wrote: > > > > > You could modify the maintenance UI experience to have an option for > > > creating additional database instances which would then execute your > > script > > > again but I'm wondering if it wouldn't be simpler to just write a small > > > application utility and put it in the start menu to allow a user to > > perform > > > database management functions like creating additional named database > > > instances. > > > > > > How do you feel about that? > > > > > > --- On Wed, 7/23/08, Daniel Zak <[EMAIL PROTECTED]> wrote: > > > > > > > From: Daniel Zak <[EMAIL PROTECTED]> > > > > Subject: Re: [WiX-users] Multiple Installs without Un-Install? > > > > To: wix-users@lists.sourceforge.net > > > > Date: Wednesday, July 23, 2008, 1:28 AM > > > > Hi Christopher, > > > > > > > > I need multiple instances only of the database. > > > > > > > > Cheers, > > > > Daniel > > > > > > > > > > > > > Message: 9 > > > > > Date: Tue, 22 Jul 2008 05:31:10 -0700 (PDT) > > > > > From: Christopher Painter > > > > <[EMAIL PROTECTED]> > > > > > Subject: Re: [WiX-users] Multiple Installs without > > > > Un-Install? > > > > > To: "General discussion for Windows Installer XML > > > > toolset." > > > > > <wix-users@lists.sourceforge.net> > > > > > Message-ID: > > > > <[EMAIL PROTECTED]> > > > > > Content-Type: text/plain; charset=us-ascii > > > > > > > > > > Windows Installer supports multiple instance > > > > installation, but the question > > > > > I have is do you need multiple instances of your > > > > product or only multiple > > > > > instances of your database? > > > > > > > > > > Christopher Painter, Author of Deployment Engineering > > > > Blog > > > > > Have a hot tip, know a secret or read a really good > > > > thread that deserves > > > > > attention? E-Mail Me > > > > > > > > > > > > > > > --- On Mon, 7/21/08, Daniel Zak > > > > <[EMAIL PROTECTED]> wrote: > > > > > > > > > > > From: Daniel Zak <[EMAIL PROTECTED]> > > > > > > Subject: [WiX-users] Multiple Installs without > > > > Un-Install? > > > > > > To: wix-users@lists.sourceforge.net > > > > > > Date: Monday, July 21, 2008, 11:51 PM > > > > > > Hello, > > > > > > > > > > > > I created a script to install an SQL Server > > > > database. A > > > > > > user needs to be > > > > > > able to run the script multiple times to install > > > > multiple > > > > > > databases. > > > > > > However, the script requires the user to first > > > > un-install > > > > > > the product (which > > > > > > does not delete the database) before being able > > > > to install > > > > > > a new database. > > > > > > > > > > > > Is there anything I can do to avoid requiring the > > > > user to > > > > > > explicitly > > > > > > un-install the product? > > > > > > > > > > > > I included an extract of the script as a text > > > > file. > > > > > > > > > > > > Thank you, > > > > > > Daniel > > > > > > ------------------------------------------------------------------------- > > > > 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 > > > > > > ------------------------------------------------------------------------- > > 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 > ------------------------------------------------------------------------- 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