SQL Change Automation and Verification in Harness
complete
W
Wild blue yonder Panda
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.
Log In
S
Stephen Atwell
marked this post as
complete
S
Stephen Atwell
Our 'Author DB Change' functionality includes a step that takes a change, appends it into your changelog, and validates the whole thing before pushing it to git. This is the 'preview and validate' step. A demo is available here: https://www.youtube.com/watch?v=W7IYeCyXjRo
This post was marked as
in progress
S
Stephen Atwell
marked this post as
planned
S
Stephen Atwell
It is possible to do this using database devops today, you can see a demo of what is currently possible here (it also links to a blog that goes through the pipeline config): https://www.youtube.com/watch?v=dd9rPz_FaWU.
I'm leaving this request open though as we have some more exciting things planned in this area.
S
Stephen Atwell
marked this post as
under review