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
