SQL Database

Octopus Deploy stores projects, environments, and deployment history in a Microsoft SQL Server Database.

SQL Server Database

Octopus works with a wide range of versions and editions of SQL Server, from a local SQL Server Express instance, all the way to an Enterprise Edition SQL Server Failover Cluster or SQL Server AlwaysOn Availability Group, or even one of the hosted database-as-a-service offerings.

The following versions of SQL Server Database are supported and automatically tested against every release of Octopus Server:

Supported editions:

• Express (free)
• Web
• Datacenter
• Standard
• Enterprise
• Microsoft Azure SQL Database
• AWS RDS SQL Database

Using SQL Server Express

The easiest and cheapest way to get started is with SQL Server Express and install the Octopus Server and SQL Server Express side-by-side on your server. This is a great way to test Octopus for a proof of concept. Depending on your needs, you might decide to use SQL Server Express, or upgrade to another supported edition.

Configuration Guidelines

The SQL Database Octopus Deploy uses can be hosted on a local SQL Server, or one of the many cloud providers. The requirements are:

• Must be running SQL Server 2016+ or Azure SQL
• Be located in the same data center as the servers/container hosts that host Octopus Deploy.

This section provides configuration walkthroughs for the popular storage options our customers use.

• Self-Managed SQL Server
• AWS RDS
• Azure SQL
• GCP SQL

Database administration and maintenance

For more information about maintaining your Octopus database, please read our database administrators guide.

Learn more

• Octopus installation

Help us continuously improve

Please let us know if you have any feedback about this page.

Send feedback

Page updated on Wednesday, May 22, 2024