Re: Open Source tool to deploy/promote PostgreSQL DDL

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 <rshepard(at)appl-ecosys(dot)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
>
>