Hi All,
I need to run multiple sql scripts from wix which will crate multiple
databases.
I wrote following code to accomplish the above task....
<Component Id="SQLComponent" Guid="C50999A0-02FD-42d5-9F65-7375318DD328">
<sql:SqlDatabase Id="DB" Database="DB1" Server="localhost"
CreateOnInstall="yes" >
<sql:SqlScript Id="DBSqlScript1" ExecuteOnInstall="yes"
BinaryKey="DatabaseSqlScript1" />
</sql:SqlDatabase>
<sql:SqlDatabase Id="DB2" Database="DB2" Server="localhost"
CreateOnInstall="yes" >
<sql:SqlScript Id="DBSqlScript2" ExecuteOnInstall="yes"
BinaryKey="DatabaseSqlScript2" />
</sql:SqlDatabase>
</Component>
where binary key are the multiple sql script files.
now when I install the msi, it creates the databases, but did not run the
first script completely, but the second script was run properly.
Now the Problem is that it executes the last script file properly. What I
speculate the problem could be is that while the first script is still
running the second script starts running, which interrupts with the first
script and rollbacks the work done by it. (this is what I think, it may or
may not be true.)
Can anybody help me with this problem????? its very urgent.
Thanks and Regards,
Chetan Garg
--
View this message in context:
http://www.nabble.com/Executing-Multiple-Sql-scripts-tf4250019.html#a12095490
Sent from the wix-users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
