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.
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-tp733310p733310.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
