4 ms·
I'm working on a system to export users from one version & instance of our SaaS application and import them into another. The cool/interesting part of this is
by btgeekboy 13y ago
I'm working on a system to export users from one version & instance of our SaaS application and import them into another.
The cool/interesting part of this is that I'm using a combination of SchemaCrawler and our homegrown upgrade/migrations kit to naively (with the only domain-specific knowledge being where to start) extract a single account from a multi-tenant database and import it into another one, even if the other one is a different version. (I only support upgrades, as downgrades would cause data loss.) Because it all runs over JDBC, it also means that I can go from one database to another - MySQL to PostgreSQL, for example.