RE: Stopping SQL service and sca.wixlib

[Rob Mensching]

K and I have discussed how to get the Server CustomActions to allow their
sequences to be overridden.  I think that Feature Request is already open.
Until that is done, you can just build a custom sca.wixlib form sources in
wix\src\ca\serverca\setup\sca.wxs to schedule the actions where you want.

-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of Alexei Boukirev
Sent: Thursday, September 15, 2005 6:38 AM
To: [hidden email]
Subject: [WiX-users] Stopping SQL service and sca.wixlib

Hello wix-users,

I'm working on setup that installs an extended procedures library/DLL for
SQL Server 2000.
I'm  not  so  worried  about initial install but rather about upgrade.  I
need to stop SQL
Server  service(s)  to replace file and I cannot schedule replacement for
next reboot as I
have  to  run  a  specific  SQL  script after I replaced file (to
load/instantiate xp_....
procedures).   It's  all good to this point and <ServiceControl ...> is my
friend.  To run
the  script I was going to use <SqlScript ...> together with the rest of
<Sql...> tags.  I
looked  at  sca.wixlib  and  was  able  to  figure  that  it  schedules
ConfigureSql after
InstallFiles (at least that's how it seems to me) in InstallExecuteSequence.
That is long
before StartServices.  It means SQL services will be stopped at the moment.

I  could  try  and  figure  it  out  from C++ sources if sca custom actions
will start SQL
Server  on  demand  when  it'll come to executing the script.   I decided to
ask here if
anybody knows whether it does so.  Maybe someone went through the similar
scenario and
could help with advice.


--
Best regards,
 Alexei




-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
WiX-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/wix-users



-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
WiX-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/wix-users

[Alexei Boukirev]

I  ended up with a custom action that both starts the instance (I have a dialog in the GUI
for  a  user  to  select  from  the list/drop-down box of instances available on the local
computer), connects with trusted security setting, and unloads ODS dll.  It also picks the
path  where  to install ODS DLLs for the instance in question.  A lot of work, and all has
to  be done before any file copying occurs.  Works fine.  By starting the instance/service
in CA I also ensure that it's running when ConfigureSql is executed.  So it all plays well
this  way.   It  does  uninstall correctly too.  So I am now satisfied with how things are
currently.

I gave it some thought and it seems like several scenarios are possible with executing SQL
scripts  during  install/uninstall/upgrade.   I  also wonder if it would make sense to add
<Condition>  as  a  child  to  <SqlString> and <SqlScript>, although this might be handled
by placing those in <Component>s and adding <Condition> to those.


Tuesday, September 20, 2005, 10:22:17 AM, you wrote:

> K and I have discussed how to get the Server CustomActions to allow their
> sequences to be overridden.  I think that Feature Request is already open.
> Until that is done, you can just build a custom sca.wixlib form sources in
> wix\src\ca\serverca\setup\sca.wxs to schedule the actions where you want.

> -----Original Message-----
> From: [hidden email]
> [mailto:[hidden email]] On Behalf Of Alexei Boukirev
> Sent: Thursday, September 15, 2005 6:38 AM
> To: [hidden email]
> Subject: [WiX-users] Stopping SQL service and sca.wixlib

> Hello wix-users,

> I'm working on setup that installs an extended procedures library/DLL for
> SQL Server 2000.
> I'm  not  so  worried  about initial install but rather about upgrade.  I
> need to stop SQL
> Server  service(s)  to replace file and I cannot schedule replacement for
> next reboot as I
> have  to  run  a  specific  SQL  script after I replaced file (to
> load/instantiate xp_....
> procedures).   It's  all good to this point and <ServiceControl ...> is my
> friend.  To run
> the  script I was going to use <SqlScript ...> together with the rest of
> <Sql...> tags.  I
> looked  at  sca.wixlib  and  was  able  to  figure  that  it  schedules
> ConfigureSql after
> InstallFiles (at least that's how it seems to me) in InstallExecuteSequence.
> That is long
> before StartServices.  It means SQL services will be stopped at the moment.

> I  could  try  and  figure  it  out  from C++ sources if sca custom actions
> will start SQL
> Server  on  demand  when  it'll come to executing the script.   I decided to
> ask here if
> anybody knows whether it does so.  Maybe someone went through the similar
> scenario and
> could help with advice.





--
Best regards,
 Alexei




-------------------------------------------------------
SF.Net email is sponsored by:
Tame your development challenges with Apache's Geronimo App Server. Download
it for free - -and be entered to win a 42" plasma tv or your very own
Sony(tm)PSP.  Click here to play: http://sourceforge.net/geronimo.php
_______________________________________________
WiX-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/wix-users