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?