what database schema version management system to use?

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: pgsql-general(at)postgresql(dot)org
Subject: what database schema version management system to use?
Date: 2016-04-06 10:55:40
Message-ID: 5704EB2C.7080402@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I am searching for a proper database schema version management system.

My criteria are the following:
0) Open-source, supports postgresql
1) Uses psql to execute changesets (to have no problems with COPY,
transaction management or sophisticated DDL commands, and to benefit
from scripting)
2) Support repeatable migrations (SQL files that get applied every time
they are changed, it is useful for functions or views tracking).

Reasonable?

But unfortunately it looks like each of Liquibase, Flyway, SqlHawk,
MigrateDB, Schema-evolution-manager, Depesz's Versioning, Alembic and
Sqitch does not satisfy some of those, right?

What DB VCS do you use and how does it related with the criteria listed
above?
Do you have any idea what other systems to try?

Regards,
Alexey

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sgringer 2016-04-06 11:02:31 PostgreSQL 9.5.1 -> PG_REWIND NOT FOUND
Previous Message Lars Arvidson 2016-04-06 10:33:16 Re: Problem after replication switchover