SQL Release

Octopus Deploy step templates reference

DLM Automation provides the following step templates to help you set up a database deployment project in Octopus Deploy:

The templates are available from the Octopus Deploy Library. For help on installing and using them, see this worked example.

We recommend creating variables for the parameter values, to allow scoping and sharing of values between steps. See Variables (Octopus Deploy documentation).

On this page:

Create Database Release

Copy this template from the Octopus Deploy Library

This step creates the database deployment resources to update the target database from a NuGet package containing the source schema. 

A step must already exist in the project that downloads a NuGet package containing the source database schema.

ParameterRequiredValue
Export pathYes

The path that the database deployment resources will be exported to.

This path is used in the Deploy from Database Release step, and tentacles used in database deployment steps must be able to access it.

Delete files in export folderNo

If files exist in the export path folder, this option deletes those files before exporting the database deployment resources.

If this option is not selected and there are files in the export path folder, the step will fail.

Database package stepYesThe step in which the NuGet package containing the source database schema was downloaded.
Target SQL Server instanceYesThe fully-qualified name of the SQL Server instance for the database that will be updated.
Target database nameYesThe name of the database that will be updated.
UsernameNo

The SQL Server username used to connect to the database.

If you leave this field and 'Password' blank, Windows authentication will be used to connect instead, using the account that runs the Tentacle service.

PasswordNo

The SQL Server password

Only required if you are using SQL Server authentication.

Filter pathNo

The location of a SQL Compare filter file (.scpf), which defines objects to include/exclude in the schema comparison. Filter files are generated by SQL Source Control.

SQL Compare optionsNo

SQL Compare options to apply when generating the update script.
Use a comma-separated list to enter multiple options.

Temporary database server connection stringNo

This feature is only useful if you’re using Migrations V2 beta.
It specifies the connection string of the SQL Server instance for a temporary database. For example, “Data Source=TempServer01”. This allows Migrations V2 beta to work with databases that have features not supported by LocalDB, such as Full-Text Search.

Added July 16th, 2015 
Transaction isolation levelNoThe transaction isolation level to be used in deployment scripts.
Ignore static dataNoExcludes changes to static data when generating the deployment resources.
Include identical objects in the change reportNoBy default, the change report only includes added, modified and removed objects. Choose this option to also include identical objects.
Added July 8th, 2015 

Deploy from Database

Copy this template from the Octopus Deploy Library

This step updates the schema of the target database to match the schema of the source database.

ParameterRequiredValue
Source SQL Server instanceYesThe fully-qualified name of the SQL Server instance for the database whose schema you want to deploy to the target database.
Source database nameYesThe name of the database whose schema you want to deploy to the target database.
UsernameNo

The SQL Server username used to connect to the source database.

If you leave this field and 'Password' blank, Windows authentication will be used to connect instead, using the account that runs the Tentacle service.

PasswordNo

The SQL Server password for the source database.

Only required if you are using SQL Server authentication.

Target SQL Server instanceYesThe fully-qualified instance name of the SQL Server for the database that will be updated.
Target database nameYesThe name of the database that will be updated.
UsernameNo

The SQL Server username used to connect to the target database.

If you leave this field and 'Password' blank, Windows authentication will be used to connect instead, using the account that runs the Tentacle service.

PasswordNo

The SQL Server password for the target database.

Only required if you are using SQL Server authentication.

Filter pathNo

Specify the location of a SQL Compare filter file (.scpf), which defines objects to include/exclude in the schema comparison. Filter files are generated by SQL Source Control.

SQL Compare optionsNo

SQL Compare options to apply when generating the update script.
Use a comma-separated list to enter multiple options.

Transaction isolation levelNoSelect the transaction isolation level to be used in deployment scripts.
Query batch timeout (in seconds)NoThe execution timeout, in seconds, for each batch of queries in the update script. The default value is 30 seconds. A value of zero indicates no execution timeout.
Added July 8th, 2015 

Deploy from Database Release

Copy this template from the Octopus Deploy Library

This step updates the schema of the target database to match that of a NuGet package containing the source database schema.

This step requires that the "Create Database Release" step has already been run, to generate the database deployment resources.

ParameterRequiredValue
Export pathYes

The path the database deployment resources were exported to.

This should be the same path specified in the "Create Database Release" step, and must be accessible to all tentacles used in database deployment steps.

Database package stepYesThe step in which the NuGet package containing the source database schema was downloaded.
Target SQL Server instanceYesThe fully-qualified name of the SQL Server instance for the database that will be updated.
Target database nameYesThe name of the database that will be updated.
UsernameNo

The SQL Server username used to connect to the database.

If you leave this field and 'Password' blank, Windows authentication will be used to connect instead, using the account that runs the Tentacle service.

PasswordNo

The SQL Server password

Only required if you are using SQL Server authentication.

Query batch timeout (in seconds)NoThe execution timeout, in seconds, for each batch of queries in the update script. The default value is 30 seconds. A value of zero indicates no execution timeout.

Deploy from Package

Copy this template from the Octopus Deploy Library

This step updates the schema of the target database to match that of a NuGet package containing the source database schema. A step must already exist in the project that downloads a NuGet package containing the source database schema.

ParameterRequiredValue
Database package stepYesThe step in which the NuGet package containing the source database schema was downloaded.
Target SQL Server instanceYesThe fully-qualified instance name of the SQL Server for the database that will be updated.
Target database nameYesThe name of the database that will be updated.
UsernameNo

The SQL Server username used to connect to the target database.

If you leave this field and 'Password' blank, Windows authentication will be used to connect instead, using the account that runs the Tentacle service.

PasswordNo

The SQL Server password for the target database.

Only required if you are using SQL Server authentication.

Filter pathNo

Specify the location of a SQL Compare filter file (.scpf), which defines objects to include/exclude in the schema comparison. Filter files are generated by SQL Source Control.

SQL Compare optionsNo

SQL Compare options to apply when generating the update script.
Use a comma-separated list to enter multiple options.

Temporary database server connection stringNoThis feature is only useful if you’re using Migrations V2 beta.
It specifies the connection string of the SQL Server instance for a temporary database. For example, “Data Source=TempServer01”. This allows Migrations V2 beta to work with databases that have features not supported by LocalDB, such as Full-Text Search.
Added July 16th, 2015  
Transaction isolation levelNoSelect the transaction isolation level to be used in deployment scripts.
Ignore static dataNoExcludes changes to static data when generating the deployment resources.
Query batch timeout (in seconds)NoThe execution timeout, in seconds, for each batch of queries in the update script. The default value is 30 seconds. A value of zero indicates no execution timeout.

Didn't find what you were looking for?