Re: [aerogear-dev] Dealing with UPS Keycloak data post-datasource-split

On Wed, May 6, 2015 at 10:26 PM, Matthias Wessendorf <matzew(a)apache.org <javascript:_e(%7B%7D,'cvml','matzew@apache.org');>> wrote: > > > On Wed, May 6, 2015 at 8:27 PM, Douglas Campos <qmx(a)qmx.me > <javascript:_e(%7B%7D,'cvml','qmx@qmx.me');>> wrote: > >> Howdy y'all! >> >> I'm revisiting migration strategies for UPS master, and we have a tough >> situation to deal with. >> >> Since we have moved keycloak to its own DataSource, there are KC >> leftovers at UPS database which need to be cleaned up. >> >> 1) Any suggestions on how to provide a migration path? >> Since the tables are intertwined with UPS tables, it's not a matter of >> doing a db dump/restore... >> > > how are they intertwined? Is UPS stuff stored in KC tables, or vice versa? > UPS tables live alongside KC tables on the same schema/database > >> 2) How to ensure we can safely get rid of the leftover tables on UPS >> DataSource? >> I can easily provide migrations which just nuke the tables from the >> face of the earth, >> > > that's good, but > > >> but how to do this without data loss? >> > > I don't know :-) I wonder if we just can not move the data to a new > datasource. > We can, but you know how risky data migration is :)

> > > > >> >> Thoughts? >> >> _______________________________________________ >> aerogear-dev mailing list >> aerogear-dev(a)lists.jboss.org >> <javascript:_e(%7B%7D,'cvml','aerogear-dev@lists.jboss.org');> >> https://lists.jboss.org/mailman/listinfo/aerogear-dev >> > > > > -- > Matthias Wessendorf > > blog: http://matthiaswessendorf.wordpress.com/ > sessions: http://www.slideshare.net/mwessendorf > twitter: http://twitter.com/mwessendorf > > _______________________________________________ > aerogear-dev mailing list > aerogear-dev(a)lists.jboss.org > <javascript:_e(%7B%7D,'cvml','aerogear-dev@lists.jboss.org');> > https://lists.jboss.org/mailman/listinfo/aerogear-dev >