The step will compare the database from a deployment package with the target database to create a schema synchronization script deployment resource

The step will compare database from a deployment package with target database to create data synchronization script deployment resource.

This uses the .Net framework aspnet_regsql tool to create an ASPState database using the credentials provided. If the username and password are both empty then it will attempt a trusted connection.

Will create a database user using an existing server user if that database user does not exist without using SMO.

Will restore a database backup from an S3 bucket

Exports a database to a bacpac

Imports a bacpac file into an existing database.

restores a bacpac to a new database

Restores a bacpac to a new database

Runs a sql command against an Azure SQL Server database.

Create a backup of SQL Azure Database and store it in Azure Blob Storage. Requires Azure PowerShell to be installed on Tentacle machine.

This template creates a keyspace on a Cassandra server if it doesn't already exist. Note this template is written in Python and requires that pip is installed to function correctly.,

Step template to leverage Flyway to deploy migration scripts. This is the latest and greatest Flyway step template that leverages all the newest features of both Flyway and Octopus Deploy.

Database migrations using grate.

Deploy database updates using Liquibase. You can include Liquibase in the package itself or choose Download to download it during runtime. Use the Report only? option to output the SQL it will run and upload it as an Artifact. NOTE: Report only? does not work with NoSQL databases such as MongoDB

Run Liqbuibase commands against a database. You can include Liquibase in the package itself or choose Download to download it during runtime.

Adds a database user to a role

Creates a MariaDB database if it doesn't already exist.

Creates a new user account on a MariaDB database server

Adds roles to an existing user in a MongoDB database.

Creates a new database on a MongoDB server with an initial collection.

Creates a new database user on a MongoDB server.

Adds a database user to a role

Backs up a MySQL database on a windows instance hosting MySQL.

Creates a MySQL database if it doesn't already exist. This template is also compatible with MariaDB.

Creates a new user account on a MySQL database server

Serialize an Octopus project as a Terraform module and upload the resulting package to the Octopus built in feed.

Adds database user to a role

Creates a new user account on a Oracle database server

Adds database user to a role.

Creates a Postgres database if it doesn't already exist.

Creates a Postgres database if it doesn't already exist.

Creates a new user account on a Postgres database server.

Used to create a new database on a server

Used to delete a database from a server, with a possibility to remove all the data from hard drive.

To move data directly between two instances (or different databases in the same instance) using the between option introduced in Smuggler version 3.

Deploy database changes packaged with Redgate's ReadyRoll. Requires the Microsoft SQL Command Line Utilities 11 or later to be installed on the tentacle.

Creates the resources (including the SQL update script) to deploy database changes using Redgate's SQL Change Automation, and exports them as Octopus artifacts so you can review the changes before deploying.

Creates the resources (including the SQL update script) to deploy database changes using Redgate's SQL Change Automation, and exports them as Octopus artifacts so you can review the changes before deploying.

This step will use the Redgate Oracle Deployment Suite. It will create a delta sql script and report so you can review it prior to being deployed to the Oracle Server. This step will download a package containing the scripts generated by Redgate Source Control for Oracle.

Uses Redgate's SQL Change Automation to deploy a source schema to a SQL Server database without a review step.

Uses the deployment resources from the 'Redgate - Create Database Release' step to deploy the database changes using Redgate's SQL Change Automation.

Uses the deployment resources from the 'Redgate - Create Database Release' step to deploy the database changes using Redgate's SQL Change Automation.

Uses Redgate's SQL Change Automation to deploy a package containing a database schema to a SQL Server database, without a review step.

Uses Redgate's SQL Change Automation to deploy a package containing a database schema to a SQL Server database, without a review step.

Creates a database clone with Redgate SQL Clone.

Creates a database image with Redgate SQL Clone.

Deletes a database clone with Redgate SQL Clone.

Deletes a database image with Redgate SQL Clone.

Database migrations using RoundhousE.

Runs Update-Database to update the database to the latest Entity Framework migrations

This step will run a script file on an Oracle database using SQLPlus. This script assumes you have SQLPlus installed and a TNS entry for the database you wish to connect to.

Adds a database user to a role without using SMO. Please note: this is NOT for server roles or server users.

Backup a MS SQL Server database to the file system.

Creates a database if the database does not exist without using SMO.

Creates a database if the database does not exist without using SMO.

Requires SMO to be installed on the machine where this step will be run.

Will create a database user using an existing server user if that database user does not exist without using SMO.

This uses Sql Management Objects to create a database. If the username and password are both empty then it will attempt a trusted connection using integrated security.

Deletes a database from the server without using SMO.

This uses Sql Management Objects to drop a database if it exists. If the username and password are both empty then it will attempt a trusted connection.

Given a path to a folder containing SQL scripts, this module will execute each script on the database server and catalog provided. It will execute them in order based on their name.

Executes SQL script file(s) against the specified database using the SQLServer Powershell Module. This template includes an Authentication selector and supports SQL Authentication, Windows Authentication, and Azure Managed Identity.

Executes SQL script file(s) against the specified database using either SQL or Windows authentication. SQL Scripts can be hardcoded value or can be from an extracted NuGet package.

Will fix an orphaned user in the database by re-associating the SID.

This step template will run a fragmentation query on your Octopus database and report the results of the tables.

Restore a MS SQL Server database to the file system.

Tests a SQL Server connection string by attempting to connect to the database.

Given an existing .bacpac in Azure Storage this template restores a SQL Azure database.

A Template which will deploy any .ISPAC files from the published package step selected to the SQL Server catalog database.

This step downloads the latest version of Octopus Server and upgrades an existing instance. Run this step on a tentacle that has privileges to install software and start/stop services on the target server.