A verbose log file should show you everything that is being done and from there you can figure out why things were skipped.
-----Original Message----- From: cemiles [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2008 09:31 To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Patching SQL Database with script It's not in a CA I authored, but in ExecuteSqlStrings I thought. Here's what I'm working with. msi installs fine and does what i want, then the msp succeeds (even if i set the patch script's continueonerror="no"). that's the part that's baffling, like it won't even fire off even thought i've conditioned it to. (PRECONDITION: NT login is manually created for us on the remote server prior to running install/patch). <util:User Id="sysadmin" Name="[DBUSERNAME]" Password="[DBUSERPW]"/> <DirectoryRef Id="INSTALLDIR"> <Component Id="sql_db_remote_sql" Guid="" SharedDllRefCount="yes"> <Condition>SQLTYPE=3 AND NOT PATCH</Condition> <sql:SqlDatabase Id="sqltest_remote_sql" Database="[DBNAME]" CreateOnInstall="yes" CreateOnReinstall="no" DropOnUninstall="no" Server="[DBSERVERNAME]" User="sysadmin" > <sql:SqlString Id="executesqlstring_grantlogin_sql" Sequence="1" ExecuteOnInstall="yes" SQL="USE [DBNAME] EXEC sp_grantlogin '[PROMPTEDDOMAIN]\[PROMPTEDUSER]'" ContinueOnError="no" /> <sql:SqlString Id="executesqlstring_defaultdb_sql" Sequence="2" ExecuteOnInstall="yes" SQL="EXEC sp_defaultdb '[PROMPTEDDOMAIN]\[PROMPTEDUSER]', '[DBNAME]'" ContinueOnError="no" /> <sql:SqlString Id="executesqlstring_changedb_owner_sql" Sequence="3" ExecuteOnInstall="yes" SQL="EXEC sp_changedbowner '[PROMPTEDDOMAIN]\[PROMPTEDUSER]'" ContinueOnError="no" /> <sql:SqlScript Id="executesqlscript_remote_sql" Sequence="4" ExecuteOnInstall="yes" ExecuteOnReinstall="yes" BinaryKey="SqlScript1" ContinueOnError="no" /> </sql:SqlDatabase> <CreateFolder></CreateFolder> </Component> </DirectoryRef> <DirectoryRef Id="INSTALLDIR"> <Component Id="sql_db_remote_sql_patch" Guid="" SharedDllRefCount="yes"> <Condition>SQLTYPE=3 AND PATCH</Condition> <sql:SqlScript Id="executesqlscript_remote_sql_patch" SqlDb="sqltest_remote_sql" ExecuteOnInstall="yes" ExecuteOnReinstall="yes" BinaryKey="SqlScript1" ContinueOnError="no" /> <CreateFolder></CreateFolder> </Component> </DirectoryRef> </Fragment> </Wix> It's just a little frustrating is all. We're trying to release sometime soon and I've turned up nothing in my pursuit of an answer. And we have a little executable program that we 'could' launch after the patch finishes (and the kicker here is whenever you specify the dbname/dbservername w/i that exe it runs the scripts fine on the remote machine). Wilson, Phil wrote: > > If this code is running in a custom action, it is impersonated or not? > > Phil Wilson > > -----Original Message----- > From: cemiles [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 26, 2008 9:10 AM > To: wix-users@lists.sourceforge.net > Subject: Re: [WiX-users] Patching SQL Database with script > > > Is there an answer for this? I still can't get it to work, and I've seen > others complain too. I can post my code if someone has time to help out. > > > cemiles wrote: >> >> 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-tp713025p1581637.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 > > > > ------------------------------------------------------------------------- > 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-tp713025p1581751.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 ------------------------------------------------------------------------- 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
