[keycloak-dev] Database migration

[Stian Thorgersen]

Yep, but then someone came along and talked about millions of users ;)

----- Original Message -----
> From: "Marek Posolda" <mposolda at redhat.com>
> To: "Stian Thorgersen" <stian at redhat.com>, "keycloak dev" <keycloak-dev at lists.jboss.org>
> Sent: Monday, 6 October, 2014 4:10:57 PM
> Subject: Re: [keycloak-dev] Database migration
> 
> 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
> 
>