Feature Requests

Currently, Harness does not support SQL change automation to automatically generate migration scripts or verify their SQL accuracy before check-in to git. It would be beneficial to have these features to streamline the database DevOps process, ensuring accuracy and efficiency in managing database changes.

In our organization, we use a custom manifest script with Helm to dynamically select repositories based on pipeline variables, such as using 'helm-prod' for release builds and 'helm-dev' for non-release builds. We need similar functionality for DB DevOps to dynamically pull schema artifacts from different Artifactory repositories. This feature would greatly enhance our deployment process and align with our current practices.

Module Database DevOps Rollbacks aren't as intuitive with Database DevOps. We are requesting that the process for rolling back a changeset that has been applied be as simple as it is for rolling back other deployments (ie. Helm). Currently, we have rollback functionality backed into the pipeline, but we want that to be handled separate from the deployment pipeline like can be done with services.

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.

Need for two primary database tasks 1)We would like to have a step with the ability to run sql queries on databases and return errors upon failure .2)Also we will like to have a step with the ability to run sql plus scripts or sql scripts. we would prefer Harness to provide a way to have different database tasks automated by supporting them out of the box.