We use Octopus Deploy to manage our internal releases. In one of our environments we have multiple instances of our database, each containing different data, which need to be kept in sync when a release is published to this environment.
It's working fine for a single database on a single server. Variables exist for DatabaseServer and DatabaseName and the scripts are deployed to this database without any problems.
Is it possible to sepecify multiple instances in the DatabaseServer and DatabaseName variables so that each instance would be updated when a release was deployed? I've looked into how sqlcmd would actually handle this and I haven't found any concrete information.
Thanks for your help.
Thanks for getting in touch. Unfortunately it is currently not possible to specify multiple DatabaseServer / DatabaseName instances in the Octopus variables.
A simple enhancement to ReadyRoll we could do is to assume “localhost” for the database instance, but that would only work if the former case is true (you would just need a Tentacle on each database server).
If it is the latter, then we may need to get a bit more creative. Possibly a comma-delimited string of database names would be needed, as I don’t believe Octopus supports array variables.
This question has received the maximum number of answers.