Deploying on OctoPack Error

Question

I'm using a tutorial to deploy a dacpac through OctoPack.

http://kwilson.me.uk/blog/deploy-a-database-project-dacpac-using-octopusdeploy-and-powershell/

I'm getting an error saying the following:

Exception calling "Deploy" with "5" argument(s): "DacInstance with the specified instance_id does not exist." At Deploy.ps1 + $d.Deploy <<<< ($dp, $dbName, $TRUE, $dacProfile.DeployOptions) + CategoryInfo : NotSpecified: (:) [], ParentContainsErrorRecordException + FullyQualifiedErrorId : DotNetMethodException

Has anyone else faced this issue? What's causing it? It says there's 5 arguments but I'm only counting 4, and none of them are instance_id.

Answer 1

From experience I can tell that the Octopus Deploy Community Step Template SQL - Deploy DACPAC works very well. No need to write PowerShell scripts. Add this Step Template to Octopus, add it to your project, fill in the variables and off you go.