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
