Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I usually use straight powershell or msbuild for this. I try to avoid the flaky msdeploy. In msbuild you can use the very handy msbuild extension pack thus, so assuming you can copy files to your target destination (Robocopy is handy for that) this will do the rest:</p> <pre><code>&lt;Project ToolsVersion="4.0" DefaultTargets="InstallService" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"&gt; &lt;UsingTask AssemblyFile="..\packages\MSBuild.Extension.Pack.1.2.0\lib\net40\MSBuild.ExtensionPack.dll" TaskName="MSBuild.ExtensionPack.Computer.WindowsService"/&gt; &lt;PropertyGroup&gt; &lt;MachineName Condition="$(MachineName)==''"&gt;&lt;/MachineName&gt; &lt;ServiceName Condition="$(ServiceName)==''"&gt;&lt;/ServiceName&gt; &lt;ServicePath Condition="$(ServicePath)==''"&gt;&lt;/ServicePath&gt; &lt;User Condition="$(User)==''"&gt;&lt;/User&gt; &lt;Password Condition="$(Password)==''"&gt;&lt;/Password&gt; &lt;SuppressStart Condition="$(SuppressStart)==''"&gt;&lt;/SuppressStart&gt; &lt;/PropertyGroup&gt; &lt;Target Name="CheckProperties" BeforeTargets="StopService"&gt; &lt;Message Text="MachineName: $(MachineName)"/&gt; &lt;Message Text="ServiceName: $(ServiceName)"/&gt; &lt;Message Text="ServicePath: $(ServicePath)"/&gt; &lt;Message Text="User : $(User)"/&gt; &lt;Message Text="SuppressStart : $(SuppressStart)"/&gt; &lt;/Target&gt; &lt;Target Name="StopService" BeforeTargets="InstallService"&gt; &lt;MSBuild.ExtensionPack.Computer.WindowsService TaskAction="CheckExists" ServiceName="$(ServiceName)" MachineName="$(MachineName)"&gt; &lt;Output TaskParameter="Exists" PropertyName="DoesExist"/&gt; &lt;/MSBuild.ExtensionPack.Computer.WindowsService&gt; &lt;MSBuild.ExtensionPack.Computer.WindowsService TaskAction="Stop" ServiceName="$(ServiceName)" MachineName="$(MachineName)" Condition="$(DoesExist)=='True'"&gt; &lt;/MSBuild.ExtensionPack.Computer.WindowsService&gt; &lt;/Target&gt; &lt;Target Name="StartService" AfterTargets="InstallService"&gt; &lt;MSBuild.ExtensionPack.Computer.WindowsService TaskAction="CheckExists" ServiceName="$(ServiceName)" MachineName="$(MachineName)"&gt; &lt;Output TaskParameter="Exists" PropertyName="DoesExist"/&gt; &lt;/MSBuild.ExtensionPack.Computer.WindowsService&gt; &lt;MSBuild.ExtensionPack.Computer.WindowsService TaskAction="Start" ServiceName="$(ServiceName)" MachineName="$(MachineName)" Condition="$(DoesExist)=='True' And $(SuppressStart)=='False'" RetryAttempts="20"&gt; &lt;/MSBuild.ExtensionPack.Computer.WindowsService&gt; &lt;Message Text="Service $(ServiceName) set not to start" Condition="$(SuppressStart)=='True'" Importance="High" /&gt; &lt;/Target&gt; &lt;Target Name="InstallService"&gt; &lt;PropertyGroup&gt; &lt;ServiceExeExists Condition="Exists('$(ServicePath)')"&gt;True&lt;/ServiceExeExists&gt; &lt;/PropertyGroup&gt; &lt;Message Text="Installing $(ServicePath) %(ServiceName.Identity)" Importance="high"/&gt; &lt;MSBuild.ExtensionPack.Computer.WindowsService TaskAction="CheckExists" ServiceName="$(ServiceName)" MachineName="$(MachineName)"&gt; &lt;Output TaskParameter="Exists" PropertyName="DoesExist"/&gt; &lt;/MSBuild.ExtensionPack.Computer.WindowsService&gt; &lt;Message Text="Installed $(ServiceName) $(ServicePath) for $(User) and $(Password)" Importance="high"/&gt; &lt;MSBuild.ExtensionPack.Computer.WindowsService TaskAction="Install" ServiceName="$(ServiceName)" User="$(User)" Password="$(Password)" ServicePath="$(ServicePath)" MachineName="$(MachineName)" Condition="!$(DoesExist)"/&gt; &lt;MSBuild.ExtensionPack.Computer.WindowsService TaskAction="SetAutomatic" ServiceName="$(ServiceName)" MachineName="$(MachineName)" Condition="!$(DoesExist)"/&gt; &lt;Warning Text="%(ServiceName.Identity) service already exists" Condition="$(DoesExist)"/&gt; &lt;/Target&gt; &lt;/Project&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PODeploy windows services from team city
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJames Woolfenden
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PODeploy windows services from team city
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COWithout having too much experience with msdeploy (used it a couple of times but never really understood how it works "under the hoods"), I must admit that I too feel that it's kind of flaky. That's just opinions however, but I ended up using msbuild with copy-commands and a couple of bat-files. Your solution seems more robust, but needs as you say yourself some kind of fileshare access. In our case we did! So this solution works & I will mark it as an answer. Do you know how long "uninstall service" or "stop service" will wait for the service to gracefully stop? Forever?
      singulars
      1. PO
      1. USmarko
    2. COHi Marko glad i could help, from the online docs http://www.msbuildextensionpack.com/help/4.0.8.0/index.html it says the that the retryattempts property is defaulted to 60.
      singulars
      1. PO
      1. USJames Woolfenden
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload