Standardize deployments for all DB types | Feature Requests | harness

Standardize deployments for all DB types

complete

Brief Angelfish

Module - Database DevOps
Currently, we need to design multiple pipelines for different database types. This makes the process of integrating with our deployment systems more complex. We are requesting that deployment pipelines should function regardless of the database type. Instead of having a pipeline for deployments to Oracle databases designed one way and another for MSSQL databases, we would like to be able to have one pipeline that can deploy to both.
From what we've understood so far, limitations with Oracle have caused for us to design a pipeline specific to Oracle deployments. We need a pipeline that can deploy to all databases and handle the rollbacks properly for each as needed.

January 13, 2025

Stephen Atwell

marked this post as

complete

Stephen Atwell

have added a first class 'mark failed changesets as applied' setting in the step. this can be used for implementing this logic. both oracle and mssql will need the same state for it, which is supported.

This post was marked as

in progress

Stephen Atwell

marked this post as

planned

Stephen Atwell

For this HArness is planning to add an ability to have a database devops apply step automatically run the rollback scripts on any changesets that failed.