Windows Installer XML (WiX) toolset

›

wix-users

Multiple Installs without Un-Install?

11 Messages

Daniel Zak

Multiple Installs without Un-Install?

Reply Threaded

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@...
https://lists.sourceforge.net/lists/listinfo/wix-users

Christopher Painter

Re: Multiple Installs without Un-Install?

Reply Threaded

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 <die.fragen@...> wrote:

> From: Daniel Zak <die.fragen@...>
> Subject: [WiX-users] Multiple Installs without Un-Install?
> To: wix-users@...
> 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@...
> https://lists.sourceforge.net/lists/listinfo/wix-users

Daniel Zak

Re: Multiple Installs without Un-Install?

Reply Threaded

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 <chrpai@...>
> Subject: Re: [WiX-users] Multiple Installs without Un-Install?
> To: "General discussion for Windows Installer XML toolset."
> <wix-users@...>
> Message-ID: <816270.33631.qm@...>
> 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 <die.fragen@...> wrote:
>
> > From: Daniel Zak <die.fragen@...>
> > Subject: [WiX-users] Multiple Installs without Un-Install?
> > To: wix-users@...
> > 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

Christopher Painter

Re: Multiple Installs without Un-Install?

Reply Threaded

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 <die.fragen@...> wrote:

> From: Daniel Zak <die.fragen@...>
> Subject: Re: [WiX-users] Multiple Installs without Un-Install?
> To: wix-users@...
> 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
> <chrpai@...>
> > Subject: Re: [WiX-users] Multiple Installs without
> Un-Install?
> > To: "General discussion for Windows Installer XML
> toolset."
> > <wix-users@...>
> > Message-ID:
> <816270.33631.qm@...>
> > 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
> <die.fragen@...> wrote:
> >
> > > From: Daniel Zak <die.fragen@...>
> > > Subject: [WiX-users] Multiple Installs without
> Un-Install?
> > > To: wix-users@...
> > > 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@...
> https://lists.sourceforge.net/lists/listinfo/wix-users

Daniel Zak

Re: Multiple Installs without Un-Install?

Reply Threaded

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 <
chrpai@...> 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 <die.fragen@...> wrote:
>
> > From: Daniel Zak <die.fragen@...>
> > Subject: Re: [WiX-users] Multiple Installs without Un-Install?
> > To: wix-users@...
> > 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
> > <chrpai@...>
> > > Subject: Re: [WiX-users] Multiple Installs without
> > Un-Install?
> > > To: "General discussion for Windows Installer XML
> > toolset."
> > > <wix-users@...>
> > > Message-ID:
> > <816270.33631.qm@...>
> > > 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
> > <die.fragen@...> wrote:
> > >
> > > > From: Daniel Zak <die.fragen@...>
> > > > Subject: [WiX-users] Multiple Installs without
> > Un-Install?
> > > > To: wix-users@...
> > > > 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@...
> > 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@...
> https://lists.sourceforge.net/lists/listinfo/wix-users
>

John Nannenga

Re: Multiple Installs without Un-Install?

Reply Threaded

> 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: wix-users-bounces@... [mailto:wix-users-bounces@...] On Behalf Of Daniel Zak
Sent: Wednesday, July 23, 2008 12:05 PM
To: chrpai@...; 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 <
chrpai@...> wrote:

-------------------------------------------------------------------------
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@...
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@...
https://lists.sourceforge.net/lists/listinfo/wix-users

Christopher Painter

Re: Multiple Installs without Un-Install?

Reply Threaded

It sounds like your MSI doesn't really install a product but is just a wrapper for some sort of configuration utility that is designed to create database instances and quit.

Does that sound right?

--- On Wed, 7/23/08, Daniel Zak <die.fragen@...> wrote:

> From: Daniel Zak <die.fragen@...>
> Subject: Re: [WiX-users] Multiple Installs without Un-Install?
> To: chrpai@..., "General discussion for Windows Installer XML toolset." <wix-users@...>
> Date: Wednesday, July 23, 2008, 12:04 PM
> 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 <
> chrpai@...> 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
> <die.fragen@...> wrote:
> >
> > > From: Daniel Zak <die.fragen@...>
> > > Subject: Re: [WiX-users] Multiple Installs
> without Un-Install?
> > > To: wix-users@...
> > > 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
> > > <chrpai@...>
> > > > Subject: Re: [WiX-users] Multiple Installs
> without
> > > Un-Install?
> > > > To: "General discussion for Windows
> Installer XML
> > > toolset."
> > > >
> <wix-users@...>
> > > > Message-ID:
> > >
> <816270.33631.qm@...>
> > > > 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
> > > <die.fragen@...> wrote:
> > > >
> > > > > From: Daniel Zak
> <die.fragen@...>
> > > > > Subject: [WiX-users] Multiple Installs
> without
> > > Un-Install?
> > > > > To: wix-users@...
> > > > > 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@...
> > >
> 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@...
> > https://lists.sourceforge.net/lists/listinfo/wix-users
> >

Daniel Zak

Re: Multiple Installs without Un-Install?

Reply Threaded

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 <John.Nannenga@...>
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: wix-users-bounces@... [mailto:
> wix-users-bounces@...] On Behalf Of Daniel Zak
> Sent: Wednesday, July 23, 2008 12:05 PM
> To: chrpai@...; 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 <
> chrpai@...> 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 <die.fragen@...> wrote:
> >
> > > From: Daniel Zak <die.fragen@...>
> > > Subject: Re: [WiX-users] Multiple Installs without Un-Install?
> > > To: wix-users@...
> > > 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
> > > <chrpai@...>
> > > > Subject: Re: [WiX-users] Multiple Installs without
> > > Un-Install?
> > > > To: "General discussion for Windows Installer XML
> > > toolset."
> > > > <wix-users@...>
> > > > Message-ID:
> > > <816270.33631.qm@...>
> > > > 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
> > > <die.fragen@...> wrote:
> > > >
> > > > > From: Daniel Zak <die.fragen@...>
> > > > > Subject: [WiX-users] Multiple Installs without
> > > Un-Install?
> > > > > To: wix-users@...
> > > > > 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@...
> > > 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@...
> > 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@...
> 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@...
> https://lists.sourceforge.net/lists/listinfo/wix-users
>

John Nannenga

Re: Multiple Installs without Un-Install?

Reply Threaded

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: wix-users-bounces@... [mailto:wix-users-bounces@...] 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 <John.Nannenga@...>
wrote:

Christopher Painter

Re: Multiple Installs without Un-Install?

Reply Threaded

He emailed me off list. Basically his product doesn't actually install anything. He's looking at a fake MSI design where he basically just wants to leverage MSI/WiX MSSQL CA's since that's the way other teams have done it where he works.

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 Wed, 7/23/08, John Nannenga <John.Nannenga@...> wrote:

> From: John Nannenga <John.Nannenga@...>
> Subject: Re: [WiX-users] Multiple Installs without Un-Install?
> To: "General discussion for Windows Installer XML toolset." <wix-users@...>
> Date: Wednesday, July 23, 2008, 10:17 PM
> 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: wix-users-bounces@...
> [mailto:wix-users-bounces@...] 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
> <John.Nannenga@...>
> 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: wix-users-bounces@... [mailto:
> > wix-users-bounces@...] On Behalf Of
> Daniel Zak
> > Sent: Wednesday, July 23, 2008 12:05 PM
> > To: chrpai@...; 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
> <
> > chrpai@...> 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
> <die.fragen@...> wrote:
> > >
> > > > From: Daniel Zak
> <die.fragen@...>
> > > > Subject: Re: [WiX-users] Multiple Installs
> without Un-Install?
> > > > To: wix-users@...
> > > > 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
> > > > <chrpai@...>
> > > > > Subject: Re: [WiX-users] Multiple
> Installs without
> > > > Un-Install?
> > > > > To: "General discussion for
> Windows Installer XML
> > > > toolset."
> > > > >
> <wix-users@...>
> > > > > Message-ID:
> > > >
> <816270.33631.qm@...>
> > > > > 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
> > > > <die.fragen@...> wrote:
> > > > >
> > > > > > From: Daniel Zak
> <die.fragen@...>
> > > > > > Subject: [WiX-users] Multiple
> Installs without
> > > > Un-Install?
> > > > > > To:
> wix-users@...
> > > > > > 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
> > &