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 On Tue, Jul 10, 2018 at 6:22 PM, Rich Shepard <rshep...@appl-ecosys.com> wrote: > On Tue, 10 Jul 2018, Hustler DBA wrote: > > A client of mine is looking for an open source tool to deploy and promote >> PostgreSQL DDL changes through database environments as part of SDLC. What >> tools (open source) does the community members use? I normally use >> scripts, but they want something open source. >> > > Neil, > > I'm far from a professional DBA, but scripts are certainly open source > because they're text files. > > To track changes for almoste everything I highly recommend Git for > version > control. It's distributed and can handle most types of files. I use it for > tracking coding projects and well as report and other text documents that > are edited and revised prior to release. > > Rich > >
