<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, May 7, 2015 at 4:58 AM, Erik Jan de Wit <span dir="ltr"><<a href="mailto:edewit@redhat.com" target="_blank">edewit@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Even though keycloak and UPS used to share the schema I'm pretty sure<br>
that no data from UPS has ended up in Keycloak and visa versa. Because<br>
there is no direct hibernate keycloak class usage in UPS, therefore<br>
there is no way for UPS to store data in keycloak tables.<br>
<br>
So I propose to nuke the keycloak tables that are left over in the UPS schema.<br></blockquote><div><br></div><div>Sure, what about the potential user data that might be still living there? That's exactly why I'm bringing this to ag-dev :)</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div class="h5"><br>
On Thu, May 7, 2015 at 7:22 AM, Matthias Wessendorf <<a href="mailto:matzew@apache.org">matzew@apache.org</a>> wrote:<br>
><br>
><br>
> On Thursday, May 7, 2015, Douglas Campos <<a href="mailto:qmx@qmx.me">qmx@qmx.me</a>> wrote:<br>
>><br>
>><br>
>><br>
>> On Wed, May 6, 2015 at 10:26 PM, Matthias Wessendorf <<a href="mailto:matzew@apache.org">matzew@apache.org</a>><br>
>> wrote:<br>
>>><br>
>>><br>
>>><br>
>>> On Wed, May 6, 2015 at 8:27 PM, Douglas Campos <<a href="mailto:qmx@qmx.me">qmx@qmx.me</a>> wrote:<br>
>>>><br>
>>>> Howdy y'all!<br>
>>>><br>
>>>> I'm revisiting migration strategies for UPS master, and we have a tough<br>
>>>> situation to deal with.<br>
>>>><br>
>>>> Since we have moved keycloak to its own DataSource, there are KC<br>
>>>> leftovers at UPS database which need to be cleaned up.<br>
>>>><br>
>>>> 1) Any suggestions on how to provide a migration path?<br>
>>>> Since the tables are intertwined with UPS tables, it's not a matter of<br>
>>>> doing a db dump/restore...<br>
>>><br>
>>><br>
>>> how are they intertwined? Is UPS stuff stored in KC tables, or vice<br>
>>> versa?<br>
>><br>
>><br>
>> UPS tables live alongside KC tables on the same schema/database<br>
>><br>
>>><br>
>>>><br>
>>>> 2) How to ensure we can safely get rid of the leftover tables on UPS<br>
>>>> DataSource?<br>
>>>> I can easily provide migrations which just nuke the tables from the<br>
>>>> face of the earth,<br>
>>><br>
>>><br>
>>> that's good, but<br>
>>><br>
>>>><br>
>>>> but how to do this without data loss?<br>
>>><br>
>>><br>
>>> I don't know :-) I wonder if we just can not move the data to a new<br>
>>> datasource.<br>
>><br>
>><br>
>> We can, but you know how risky data migration is :)<br>
><br>
><br>
> back to one schema, for 1.1.0 and do clean separation on 1.2.0?<br>
><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>>><br>
>>>><br>
>>>> Thoughts?<br>
>>>><br>
>>>> _______________________________________________<br>
>>>> aerogear-dev mailing list<br>
>>>> <a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
>>>> <a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>> --<br>
>>> Matthias Wessendorf<br>
>>><br>
>>> blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>
>>> sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>
>>> twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a><br>
>>><br>
>>> _______________________________________________<br>
>>> aerogear-dev mailing list<br>
>>> <a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
>>> <a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br>
>><br>
>><br>
><br>
><br>
> --<br>
> Sent from Gmail Mobile<br>
><br>
> _______________________________________________<br>
> aerogear-dev mailing list<br>
> <a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
> <a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br>
<br>
<br>
<br>
--<br>
</div></div>Cheers,<br>
Erik Jan<br>
<div class="HOEnZb"><div class="h5">_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br>
</div></div></blockquote></div><br></div></div>