We have a webservice package and a database package. We run the webservice package one 1 or more servers while we only run the database package on a single server.
We started with a single package that installed both. That caused problems because we could not choose separately when to deploy the webservice and when to deploy the database. Now we have two packages. The database package used to install the database deployment tools _and_ deploy the database using those tools. Now it only installs the tools. The database deployment needs to be started separately. Perhaps in the future we can combine both packages again and allow database deployment from _any_ server with the webservice installed. That does mean that we *MUST* install the webservice to get access to the tools for database deployment. Hmm... perhaps we'll keep them separate... Edwin G. Castro Software Developer - Staff Digital Channels Fiserv Office: 503-746-0643 Fax: 503-617-0291 www.fiserv.com Please consider the environment before printing this e-mail > -----Original Message----- > From: Michael Osmond [mailto:mosm...@baytech.com.au] > Sent: Wednesday, March 14, 2012 5:08 PM > To: chr...@iswix.com; General discussion for Windows Installer XML toolset.; > John Cooper > Subject: Re: [WiX-users] Running a single MSI on the same machine more > than once concurrently > > Hi > > >From experience of shipping to customers an installer that can do both > scenarios, the two part install might be intuitive, but it's a right pain in > practice. I now avoid doing the two part installs if at all possible. > > Also the single install location is generally much easier if the database is > moved (depending on app design). We change a single registry entry > dbServer, and that's it for the install. When the DB Install is on the > database > server you end up with all sorts of contortions when the database is moved. > > Michael > > > -----Original Message----- > From: Christopher Painter [mailto:chr...@iswix.com] > Sent: Thursday, 15 March 2012 5:20 AM > To: John Cooper; General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Running a single MSI on the same machine more > than once concurrently > > Understood. Which actually illustrates why it can make sense to split the > database setup from the main install because one day you might want to > relocate the database and reconfigure the application server and it might be > difficult if only the installer knows how to service the database. > > > Still, as I said, people seem to be more concerned with me just getting it > done for them then worrying about that scenario. > > ---------------------------------------- > > From: "John Cooper" <jocoo...@jackhenry.com> > > Sent: Wednesday, March 14, 2012 12:14 PM > > To: "chr...@iswix.com" <chr...@iswix.com>, "General discussion for > Windows Installer XML toolset." <wix-users@lists.sourceforge.net> > > Subject: RE: [WiX-users] Running a single MSI on the same machine more > than once concurrently > > > Application on the server farm and database on a (separate) database server > is the norm for my applications. Reality is that the database servers > aren't even generally in the same physical location as the server farm, and > the installing account on the server farm only has just enough rights to > make the connection string authenticate and create/update a database. No > drop rights (for instance) at all. > > > -- > > John Merryweather Cooper > > Build & Install Engineer - ESA > > Jack Henry & Associates, Inc.(r) > > Shawnee Mission, KS 66227 > > Office: 913-341-3434 x791011 > > jocoo...@jackhenry.com > > www.jackhenry.com > > > -----Original Message----- > > From: Christopher Painter [mailto:chr...@iswix.com] > > Sent: Wednesday, March 14, 2012 11:19 AM > > To: General discussion for Windows Installer XML toolset.; General > discussion for Windows Installer XML toolset. > > Subject: Re: [WiX-users] Running a single MSI on the same machine more > than > once concurrently > > > I've often wondered this myself and designed my installer per customer > requirements. > > > I agree, it seems wierd to have MSI state data on one machine registering > resource data on another machine. Still, it does work in situations where > the person doing the installer has DBA rights on the instance but not SA > > rights on the instances OS. Othertimes I've restricted the instance name > > for the connection to the local machine. > > > The only way I see to solve this dilema is to remove all database > functionality from the installer and put it into a deployment/configruation > utility that can then be run multiple times. However most of my clients > have said no when I suggested this with sort of an attitude of "I want the > installer to do it, that's why I'm paying you... I don't have time to do it > myself." > > > So I usually just make sure they are happy with what I give them and > collect my $200 when I pass go. > > > FWIW, I've developed a lot of installers over the years doing various > > client/server and nTier systems so I have a lot of experience with this > > whole thing called multiple instance installers. I was writing them way > > back as far as 2005. It get's complicated because in theory everything is > > abstracted ( any layer of an nTier or C/S system can conceivably be > > installed by itself or with other layers on the same machine or different > > machines ). In practice, it's very complicated to do it right. > > > Chris > > > ---------------------------------------- > > > From: "Hoover, Jacob" <jacob.hoo...@greenheck.com> > > > Sent: Wednesday, March 14, 2012 11:07 AM > > > To: "General discussion for Windows Installer XML toolset." > > <wix-users@lists.sourceforge.net> > > > Subject: Re: [WiX-users] Running a single MSI on the same machine more > than > > > once concurrently > > > Can I ask why you aren't installing this on the database server itself? > > > I still see the need for instance transforms as you could have multiple > > > database instances locally, but it seems counter intuitive to me to have > > > an installer registered on one machine with the actual payload on a > > > different machine. > > > -----Original Message----- > > > From: Paul Taylor [mailto:paul.tay...@collercapital.com] > > > Sent: Wednesday, March 14, 2012 10:13 AM > > > To: General discussion for Windows Installer XML toolset. > > > Subject: Re: [WiX-users] Running a single MSI on the same machine more > > > than once concurrently > > > Cheers, Rob. Looks just what I am after so I'll give it a go. > > > -----Original Message----- > > > From: Rob Mensching [mailto:r...@robmensching.com] > > > Sent: 14 March 2012 15:08 > > > To: General discussion for Windows Installer XML toolset. > > > Subject: Re: [WiX-users] Running a single MSI on the same machine more > > > than once concurrently > > > The Windows Installer supports this using "instance transforms". You can > > > read about them in the MSI SDK and see the InstanceTransform element in > > > WiX. > > > On Wed, Mar 14, 2012 at 5:25 AM, Paul Taylor > > > <paul.tay...@collercapital.com>wrote: > > > > Hi all, > > > > > > > > Newbie question: > > > > > > > > I am working on a WiX project to deploy SQL Server databases to > > > > different environments and one of the requirements is the above. So > > > > the build process generates one MSI which is then executed on a > > > > deployment server passing the target server in as a variable. Two > > > questions: > > > > > > > > > > > > 1. Is this scenario do-able with WiX? > > > > > > > > 2. If the answer to 1 is yes, the first stumbling block that I > > > have > > > > come across is the need to deploy the deployment files to a directory > > > > with the server name. I am doing this by setting the INSTALLLOCATION > > > > with a custom action based on the server name being entered at > > > > executiontime. This is working fine with the first install of a new > > > > MSI but on rerunning with a different server parameter, the custom > > > > action-set INSTALLLOCATION is being overwritten with the one that was > > > > set on the first install as part of the > > > > MsiAssembly: > > > > > > > > MSI (s) (30:C0) [11:37:37:737]: Note: 1: 2205 2: 3: MsiAssembly MSI > > > > (s) (30:C0) [11:37:37:737]: Note: 1: 2228 2: 3: MsiAssembly 4: > > > > SELECT `MsiAssembly`.`Attributes`, `MsiAssembly`.`File_Application`, > > > > `MsiAssembly`.`File_Manifest`, `Component`.`KeyPath` FROM > > > > `MsiAssembly`, `Component` WHERE `MsiAssembly`.`Component_` = > > > > `Component`.`Component` AND `MsiAssembly`.`Component_` = ? > > > > MSI (s) (30:C0) [11:37:37:737]: PROPERTY CHANGE: Modifying > > > > INSTALLLOCATION property. Its current value is 'C:\Program Files > > > > (x86)\MyDeploymentDirectory\SECONDINSTALLSERVERNAME'. Its new > value: > > > > 'c:\Program Files > > > > (x86)\MyDeploymentDirectory\InvesTranRec\FIRSTINSTALLSERVERNAME'. > > > > > > > > Anyone any thoughts? > > > > > > > > Paul > > > > > > > > ________________________________ > > > > This message and its attachments are intended for the above named > > > > only. If you receive them in error, please immediately delete them and > > > > all copies of them from your system, destroy any hard copies of them > > > > and notify the sender. Coller Capital Limited and each of its > > > > associates disclaim any liability for reliance upon any statement, > > > > opinion or other writing included within this message or its > > > > attachments. Coller Capital Limited registered in England No. 3020017. > > > > Registered Office: 33 Cavendish Square London W1G 0TT. > > > > > > > > ---------------------------------------------------------------------- > > > > -------- Virtualization & Cloud Management Using Capacity Planning > > > > Cloud computing makes use of virtualization - but cloud computing also > > > > focuses on allowing computing to be delivered as a service. > > > > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > > > > _______________________________________________ > > > > WiX-users mailing list > > > > WiX-users@lists.sourceforge.net > > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > > > -- > > > virtually, Rob Mensching - http://RobMensching.com LLC > > > ------------------------------------------------------------------------ > > > ------ > > > Virtualization & Cloud Management Using Capacity Planning Cloud > > > computing makes use of virtualization - but cloud computing also focuses > > > on allowing computing to be delivered as a service. > > > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > > > _______________________________________________ > > > WiX-users mailing list > > > WiX-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > This message and its attachments are intended for the above named only. > > > If you receive them in error, please immediately delete them and all > > > copies of them from your system, destroy any hard copies of them and > > > notify the sender. Coller Capital Limited and each of its associates > > > disclaim any liability for reliance upon any statement, opinion or other > > > writing included within this message or its attachments. Coller Capital > > > Limited registered in England No. 3020017. > > > Registered Office: 33 Cavendish Square London W1G 0TT. > > > ------------------------------------------------------------------------ > > > ------ > > > Virtualization & Cloud Management Using Capacity Planning > > > Cloud computing makes use of virtualization - but cloud computing > > > also focuses on allowing computing to be delivered as a service. > > > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > > > _______________________________________________ > > > WiX-users mailing list > > > WiX-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ---------------------------------------------------------------------------- > > > -- > > > Virtualization & Cloud Management Using Capacity Planning > > > Cloud computing makes use of virtualization - but cloud computing > > > also focuses on allowing computing to be delivered as a service. > > > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > > > _______________________________________________ > > > WiX-users mailing list > > > WiX-users@lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/wix-users > > > ---------------------------------------------------------------------------- > -- > > Virtualization & Cloud Management Using Capacity Planning > > Cloud computing makes use of virtualization - but cloud computing > > also focuses on allowing computing to be delivered as a service. > > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > > _______________________________________________ > > WiX-users mailing list > > WiX-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/wix-users > > NOTICE: This electronic mail message and any files transmitted with it are > intended > > exclusively for the individual or entity to which it is addressed. The > message, > > together with any attachment, may contain confidential and/or privileged > information. > > Any unauthorized review, use, printing, saving, copying, disclosure or > distribution > > is strictly prohibited. If you have received this message in error, please > > > immediately advise the sender by reply email and delete all copies. > > > ------------------------------------------------------------------------------ > Virtualization & Cloud Management Using Capacity Planning > Cloud computing makes use of virtualization - but cloud computing > also focuses on allowing computing to be delivered as a service. > http://www.accelacomm.com/jaw/sfnl/114/51521223/ > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > ------------------------------------------------------------------------------ > This SF email is sponsosred by: > Try Windows Azure free for 90 days Click Here > http://p.sf.net/sfu/sfd2d-msazure > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
