Octopus Deploy - Execute Script File

Question

I have defined a process that consists of 2 steps:

Deploy an IIS WebSite
Execute a script file

The first step in the process executes without any issues. I am able to upload a nuget package to Octopus Server's built-in package repository and deploy this to my IIS Web Site.

For the second step in the process, where I am asked to specify a script file to run, I am unable to upload a sql file either using the built-in package repository or using a external package repository since Octopus will not allow me to upload a .sql file type.

What is the best way of specifying the SQL Script File to be run?

Should I package it along with my nuget package and then specify the script source to 'Script file inside a package' or is it possible to upload a SQL file to a repository (external or built-in) and specify that file as the SQL script file to execute?

Is there a best practice for this?

Thanks,

Sean

Is that sql file logically part of the website? Could it not be packaged as part of the same NuGet package as the website? — Alex M
– Alex M, Commented May 16, 2017 at 11:27

Ben Richards · Accepted Answer · 2017-05-16 14:18:21Z

1

By "Script file" or "Script file inside a package" Octopus means a Powershell script or Bash script. If you want to execute a SQL script as part of your deployment you have two options:

Install an existing task from the Octopus Community Library (https://library.octopusdeploy.com/listing) that executes SQL. Here are two of them:
- SQL - Execute Script - https://library.octopusdeploy.com/step-templates/73f89638-51d1-4fbb-b68f-b71ba9e86720/actiontemplate-sql-execute-script,
- SQL - Execute Script File = https://library.octopusdeploy.com/step-templates/709b5872-52e2-4cd9-9ec0-b4a135a0444c/actiontemplate-sql-execute-script-file
Create a Powershell or Bash script to execute your SQL script.

answered May 16, 2017 at 14:18

Ben Richards

3,5861 gold badge18 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kyle McClellan Over a year ago

Can you provide more information about #2? Code would be nice.

Ben Richards Over a year ago

Here are a couple of examples. stackoverflow.com/questions/8423541/… and cmatskas.com/execute-sql-query-with-powershell.

Collectives™ on Stack Overflow

Octopus Deploy - Execute Script File

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related