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

On Wed, May 6, 2015 at 8:27 PM, Douglas Campos <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 :)