I'm extremely interested in this myself. I know Rob pointed out using sqlscript/string, but I'm getting a failure on my patch as well when doing that stating 'unable to connect to database'. I've read in some forums sql db's don't lend themselves to patches. That could be completely inaccurate (just something I read somewhere). Are you still having the same troubles w/ this too 'elat' ?
elat wrote: > > Could you give a little more information? Would these new scripts need > to be included in a separate component other than my SQL Database > component? In my installer I am creating a new database and running a > script CreateTable.sql on the install. This works. For the patch I > changed the CreateTable.sql to AlterTable.sql in my Setup.wxs. I want to > include new sql scripts in the updated .msi and create a patch that will > execute the changed sql. Does it need to have a different Binary Key? > When executing the patch.msp I get an option to Change/Repair/Remove. > I've tried both Change and repair, but it seems Change is the option I > want to use since it asks for the SQL credentials. The assemblies are > getting updated but the script is not being run. I'm a little unsure how > this is all suppose to work. > > <Binary Id="CreateTable" > SourceFile="..\..\SQLScript\MigrateScripts\CreateTable.sql" /> > > <Component Id="SuiteDatabaseComponent" > Guid="d6e96011-3252-4e85-80b5-b1ff64045e88"> > <CreateFolder/> > > <!-- installs database --> > <sql:SqlDatabase Id="db1" > Server="[SQLSERVER]" > Instance="[SQLINSTANCE]" Database="SuiteWix" > CreateOnInstall="yes" > ConfirmOverwrite="yes" > DropOnUninstall="no" User="SQLUser"> > > <!-- define where the database > files are saved --> > <sql:SqlFileSpec Id="mdf" > Name="SuiteWix_Data" > > Filename="[DATABASEDIR]SuiteWiX_Data.mdf" > Size="2MB" > GrowthSize="2MB"/> > <sql:SqlLogFileSpec Id="ldf" > Name="SuiteWix_Log" > > Filename="[DATABASEDIR]SuiteWiX_Log.ldf"/> > > <!-- add reference to database > script bianarieshere --> > <sql:SqlScript Id="CreateTable" > BinaryKey="CreateTable" ExecuteOnInstall="yes"/> > </sql:SqlDatabase> > </Component> > > Eric > > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Rob > Mensching > Sent: Monday, July 28, 2008 10:39 PM > To: General discussion for Windows Installer XML toolset. > Subject: Re: [WiX-users] Patching SQL Database with script > > The SqlScript element (or SqlString if you just want to run a couple > strings). > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Eric > Latendresse > Sent: Monday, July 28, 2008 14:59 > To: General discussion for Windows Installer XML toolset. > Subject: [WiX-users] Patching SQL Database with script > > My initial installer creates the SQL database perfectly, but I want to > be able to include new SQL scripts to be run with my patches. Could > someone give me some insight on how to do this? > > > > Eric > > > > > > ------------------------------------------------------------------------ > - > 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 > > -- View this message in context: http://n2.nabble.com/Patching-SQL-Database-with-script-tp713025p1499243.html Sent from the wix-users mailing list archive at Nabble.com. ------------------------------------------------------------------------- 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
