How to run a script on Octopus Server using the data from particular package?

Legacy Uncategorised
1

I try to model SQL Server DB deployment with Octopus. We have a package with DacPacs to deploy. Octopus is very much targeted towards scenario when package is deployed on tentacle and then scripts are run there as well. In this case we don’t need to send DacPacs to SQL Server and don’t want to install tentacle there. Instead we want to run the script right on Octopus server, but it must have necessary packages available. How to do it right?
One solution which comes to mind is to install tentacle right on the server machine itself. But it looks kinda hacky, no?
Another solution would be to install tentacle to SQL Server. Would it work any better?
Also we would like to use Windows Integrated authentication. How do we make tentacle service to run under specific domain account?

Thank you!
Konstantin

2

Hi Konstantin,

Thanks for reaching out! let me give you a hand with those questions:

One solution which comes to mind is to install tentacle right on the server machine itself. But it looks kinda hacky, no?

Totally not hacky. We even have a doc for this: http://docs.octopusdeploy.com/display/OD/How+to+run+steps+on+the+Octopus+Server

Also we would like to use Windows Integrated authentication. How do we make tentacle service to run under specific domain account?

Another doc for this: http://docs.octopusdeploy.com/display/OD/Run+Tentacle+under+a+specific+user

Hope that helps!
Dalmiro

3

Thank you! That covers it.

Konstantin