Search

Blog posts

Why consider database deployment automation?

This post explores why automating scripts to deploy database changes is valuable and some of the benefits of database deployment automation.

Database deployment automation approaches

This post talks about how to get started with database deployment automation and describes the main approaches: state-based and migration scripts.

Lessons learned implementing database deployments

Exploring the pitfalls of implementing database deployments

Database deployments with Octopus and Redgate SQL Release

Cloud-native database deployment authentication

Our most popular database deployment templates have been updated with cloud-native authentication.

Automated database deployment process: case study

This article walks through the steps I used to help design an automated database deployment process.

Database deployment automation using state-based Redgate SQL Change Automation

Setting up automated database deployments with state-based Redgate SQL change automation.

Implementing an automated database deployment process

In this article, I walk through the steps I took to implement an automated database deployment process using TeamCity, Redgate, and Octopus Deploy

Database deployment automation using Octopus and Redgate Deployment Suite for Oracle

Octopus Deploy supports many database tools. Follow along as we get a CI/CD pipeline built to deploy a database change to an Oracle Database

Database migrations lessons learned

Learn about database migrations and some lessons learned from using them in the Octopus Deploy codebase.

Howto: Deploy a SQL Server database using Octopus Deploy

Automated Database Deployments Series Kick Off

Automated Database Deployments Series Kick Off

Documentation

Database examples

Examples of using Runbooks to help automate database maintenance.

Databases

Database deployments

SQL Server Database

Information about using SQL Server Database with Octopus Deploy.

Octopus database

Octopus uses a Microsoft SQL Server Database to store environments, projects, variables, releases, and deployment history.

Changing the collation of the Octopus database

Information on changing the collation of the Octopus SQL Server Database.

Database

 Create or drop the Octopus database

Install Tentacles and Workers for database deployments

Where to install Tentacles and how to configure Workers.

Database backups and rollbacks

Recommendations on backing up and rolling back a database during a failed deployment.

Database configuration

Configuring your database and Octopus Deploy for database deployments.

Backup MySQL database

With Octopus Deploy you can backup a MySQL database with a Runbook

Create sanitized database backup

How to create a sanitized database backup to send up to Octopus Support.

Restore SQL database to another environment

With Octopus Deploy you can restore a MSSQL database to another environment with a runbook.

Moving the Octopus Server database

Walk-through outlining how you can move an Octopus database from one server to another.

Create MySQL database

With Octopus Deploy you can create a MySQL database with a Runbook.

Restore SQL database

With Octopus Deploy you can restore a MSSQL database with a runbook.

Backup SQL database

With Octopus Deploy you can backup a MSSQL database with a Runbook.

How to get a database backup and encrypt your Master Key

Guides the user on producing a database backup binary file (.bak) and encrypt their Master Key to provide us with.

Recommended database permissions

Permission recommendations for database deployments.

Can't find what you are looking for? You can also search our support forum.