We're looking at this for Keycloak atm as well, and those where the two that stood out at first glance. I haven't looked in depth or tried them out yet though.

----- Original Message -----
> From: "Erik Jan de Wit" <edewit@redhat.com>
> To: "AeroGear Developer Mailing List" <aerogear-dev@lists.jboss.org>
> Sent: Monday, 6 October, 2014 5:48:53 PM
> Subject: [aerogear-dev] database migration
>
> Hi,
>
> Now that we have 2 versions out of the door, when we change stuff we need an
> easy upgrade path. Not only for the API but also for the database. Because
> we support a couple of them having something of a process would help.
>
> I’ve have used liquibase in the past. You write ‘change sets’ in yaml, json
> or if you must in xml, it will create a migration table in the database and
> execute the changes needed to bring it up to date or you can create a sql
> script that will do the same. Cool thing about this approach is that it’s
> independent of the database
>
> http://www.liquibase.org
>
> Another tool I’ve heard about, but also promising is Flyway. It’s supports
> writing migrations in sql and java comes with it’s own java api. Basically
> the same idea with regards to this migration table, but here you need to
> specify your own sql scripts. Or you can write migrations in java where
> having special named java class gets executed to update/migrate the data.
>
> http://flywaydb.org
>
> WDYT?
>
> Cheers,
> Erik Jan
>
>

> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev@lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev

_______________________________________________
aerogear-dev mailing list
aerogear-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/aerogear-dev