InstallShield has MSSQL, Oracle and MySQL support. That's as official as you are going to get. Anything else for Oracle is going to be roll your own or punt and don't have installer do it. 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
----- Original Message ---- From: ryan robin <ryanro...@gmail.com> To: General discussion for Windows Installer XML toolset. <wix-users@lists.sourceforge.net> Sent: Fri, October 22, 2010 4:51:08 AM Subject: Re: [WiX-users] [Wix-user] Run Oracle script Hi Bernd, Thanks for your help. The latter solution seems to meet my need. I'm, howerver, still looking forward to *official* ideas/solutions :) Hope that Wix will support Oracle as well as it does to MSSQL Server to make our lives easier. Regards, Ryan On Fri, Oct 22, 2010 at 3:12 PM, Bernd Truckses <bernd.truck...@mpro.de>wrote: > Hi, > > I had the same problem. I helped me out with a managed Custom Action. > The Custom Action is written in C#, uses the Oracle.DataAccess.Client > namespace, transactions, commands etc ... > > Advantages: > - full control over the DB-process (transaction handling, exception/error > handling, script preparation/manipulation, parameters, detailed logging, > etc.) > > Disadvantages: > - .Net Framework has to be installed on target machine first > - Oracle Data Access Components (ODAC) have to be installed on target > machine first > - "exotic solution" outside the regular standard of the MSI > > > Another solution would be to write a Custom Action that starts the > commandline tool SQL*PLUS in silent mode and passes logon and script > I think there's even already a built-in Custom Action for that ( > "LaunchFile" ) - see the notepad example in the Wix-Tutorial (Lesson 3 - > "Events and Actions", chapter 3.2 "Extra Actions") - > http://www.tramontana.co.hu/wix/lesson3.php#3.2 > > > Is there an "official" way to do this (apply oracle scripts, pass > parameters > to it etc...)? > That would make me quite more happy then using my Custom Action and so > including an "exotic solution" in my MSI. > > Greets, > Bernd > > > -----Original Message----- > From: ryan robin [mailto:ryanro...@gmail.com] > Sent: Freitag, 22. Oktober 2010 05:36 > To: wix-users@lists.sourceforge.net > Subject: [WiX-users] [Wix-user] Run Oracle script > > Hi Wixers, > > I'm quiet new to Wix. > > I have a OracleXE 10g. > Is there any way to run Oracle script to create/update some tables with > existing Oracle user (as it should not create new user)? > > It seems that Wix doesn't support Oracle at the moment, right? > > > Thanks, > > Ryan > > ---------------------------------------------------------------------------- > -- > Nokia and AT&T present the 2010 Calling All Innovators-North America > contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > > > > > ------------------------------------------------------------------------------ > Nokia and AT&T present the 2010 Calling All Innovators-North America > contest > Create new apps & games for the Nokia N8 for consumers in U.S. and Canada > $10 million total in prizes - $4M cash, 500 devices, nearly $6M in > marketing > Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store > http://p.sf.net/sfu/nokia-dev2dev > _______________________________________________ > WiX-users mailing list > WiX-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/wix-users > ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------------ Nokia and AT&T present the 2010 Calling All Innovators-North America contest Create new apps & games for the Nokia N8 for consumers in U.S. and Canada $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store http://p.sf.net/sfu/nokia-dev2dev _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
