I need to be able to do the following:
Create DB and run several SQL scripts.
Start a service which writes to above created database.
Stop above service.
Run additional SQL scripts that rely on data being entered in to DB by
above service.
Start service again (not a showstopper)
I have several components involved here:
A component which creates the SQL DB and runs the initial SQL scripts.
A component which installs the service and starts it on "install".
A component which has a <ServiceControl> element only referencing the
above
service with Stop="install".
A component with one <SqlString> element which references the DB created
above and is sequenced after all other scripts.
The two major issues I'm running in to are:
I was only able to get the service to stop by changing the sequence of the
StopServices to occur after StartServices. This makes sense to me, but I was
hoping there was another way. Also there seems to be no way to restart this
after the stop if I wanted to.
I just realized that all the sql probably runs at the same time dependent on
whenever the custom action is called in the Execute sequence. So if anyone
has any ideas for breaking up the sql calls, that would be helpful.
The final SQL script run in the <SqlString> element seems to be executing
immediately after the other SQL scripts even though I reference my component
which stops the service before referencing the final SqlString.
I can post source if my explanation is lacking.
I appreciate any help or suggestions. Thanks.
--
View this message in context:
http://n2.nabble.com/Restart-a-service-and-running-sql-scripts-separately-tp733310p733375.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
