On 07/10/2018 05:04 PM, Hustler DBA wrote:
Thanks Adrian and Rich,
I will propose sqitch to the client, but I think they want something
with a GUI frontend.
They want to deploy database changes, track which environments the
change was deployed to, be able to rollback a change (with a rollback
script), track when and if the change was rolled back and in which
environment/database... so pretty much a deployment and tracking GUI
software with a frontend.
In the past, for doing database deployments to Oracle, I created a
tool using PHP (frontend/backend), MySQL (repository to track
deployments and store deployment logs) and scripted the release
scripts for deployment and rollback, and had my tool manage the
scripts up the environments. The client is "looking" for something
more open source for PostgreSQL. Do we have anything similar to this?
Neil
open a github,gitlab,sorceforge repo, switch to postgres and make your
opensource
