[keycloak-dev] Database migration

[Marek Posolda]

At some point we wanted to use export/import for that?
Like:
- export whole DB content to json file with KC 1.0.Final
- Transform JSON content from 1.0.Final format to "1.1.0.Beta1" format 
(would likely need to be detyped due to possible changes in 
*Representation objects)
- Import JSON back to DB

It required re-creating DB from scratch, but on the other hand it's very 
generic and independent on model (not tightly coupled to SQL/JPA).

Marek

On 6.10.2014 13:32, Stian Thorgersen wrote:
> For 1.1.0.Beta1 the DB schema has changed (user and client sessions only). That means we'll have to provide a migration strategy. As part of testing a release we'll also have to start testing migrating a server.
>
> I found a couple tools to help migrating databases (http://flywaydb.org/, http://www.liquibase.org/). It's probably worth looking at those as they let you have a single update script for all databases.
>
> With that in mind, and the adapter clustering issues, 1.1.0.Beta1 is probably not going to be until later this week or early next week.
> _______________________________________________
> keycloak-dev mailing list
> keycloak-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-dev