You can use Octopus Deploy Step Templates to provide a user interface for common tasks. We've created a ReadyRoll step template you can drop into your process. Instead of having to use variables, you can use our step template to fill in your database connection details.

The template is available from the Octopus Deploy Library.

Copy the ReadyRoll step template to Octopus Deploy

1. Go to the ReadyRoll step template on the Octopus Deploy library website.
2. Click Copy to clipboard.
   
   

You're now ready to paste the script into Octopus Deploy:

1. In Octopus Deploy, at the top of the page, click Library.
2. On the Step templates tab, click Import.
3. In the Import window, paste the copied template into the empty field.
4. Click Import.
5. Click Save.
   
6. By default the step template uses the built-in NuGet feed. If you need to change this, click the Step tab and select the NuGet feed you want to use:
   

Add the new ReadyRoll step to your Project

1. On the project Process tab, click Add step and select ReadyRoll - Deploy Database Package.
2. In Machine roles, enter the role you want to use for database deployments.
3. In Package to deploy, enter the ID of the NuGet package you want to deploy. This must match the NuGet package ID from the NuSpec file in your ReadyRoll project.
4. In Target SQL Server instance, enter the fully qualified SQL Server instance name for the target database.
5. In Target database name, optionally enter the name of the database to deploy to. If you leave this empty, the database name within the .sqlproj file will be used instead.
6. If you want to connect using the account that runs the Tentacle service, select the Use Windows Authentication checkbox. SQL Server authentication will be used if you leave the checkbox unselected.
7. If you're using SQL Server authentication, enter the SQL Server Username and Password.
8. In Environments, optionally select the environments you want this step to run in.
9. Click Save.
   You've finished setting up your ReadyRoll step. An example is shown below:
   

Now you're set up you can create a release and perform a deployment.