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

[Douglas Campos]

On Wed, May 6, 2015 at 10:26 PM, Matthias Wessendorf <matzew at apache.org>
wrote:

>
>
> On Wed, May 6, 2015 at 8:27 PM, Douglas Campos <qmx at 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 at 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20150507/e85a36be/attachment.html