Re: [WiX-users] Multiple Installs without Un-Install?
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
Re: [WiX-users] Multiple Installs without Un-Install?
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=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Multiple Installs without Un-Install?
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=100url=/ ___ 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=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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=100url=/ ___ 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=100url=/ ___ 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=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Multiple Installs without Un-Install?
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=100url=/ ___ 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=100url=/ ___ 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=100url=/ ___ 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
Re: [WiX-users] Multiple Installs without Un-Install?
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 [EMAIL PROTECTED] wrote: From: Daniel Zak [EMAIL PROTECTED] Subject: Re: [WiX-users] Multiple Installs without Un-Install? To: [EMAIL PROTECTED], General discussion for Windows Installer XML toolset. wix-users@lists.sourceforge.net 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 [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=100url=/ ___ 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=100url=/ ___ 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=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
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=100url=/ ___ 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=100url=/ ___ 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
Re: [WiX-users] Multiple Installs without Un-Install?
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
Re: [WiX-users] Multiple Installs without Un-Install?
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 [EMAIL PROTECTED] wrote: From: John Nannenga [EMAIL PROTECTED] Subject: Re: [WiX-users] Multiple Installs without Un-Install? To: General discussion for Windows Installer XML toolset. wix-users@lists.sourceforge.net 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: [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
Re: [WiX-users] Multiple Installs without Un-Install?
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=100url=/___ 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=100url=/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Multiple Installs without Un-Install?
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=100url=/___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users