One thought would be to migrate user on-demand. I.e Migrate the user when the user logs-in / or the next time login. You would need to keep both the systems active till all users have been migrated. Again, this depends on the type of application that you are running but for some apps this mechanism works better than bulk migrate and it takes care of any real-time data that the app maintains. Arun On Tue, May 22, 2018 at 3:40 AM, Chris Latta <chris.latta(a)dovetailgames.com&gt; wrote: > Hi, > > We are in the process of upgrading from 2.5.5 to 4.0.0 and have had to > switch from MongoDB to MySQL. We have been able to export our user base but > with 280k+ users to import back into Keycloak this is proving troublesome. > The import process takes 25 mins to import one file of 500 users, which > doesnt really seem practical as that would take us approximately 9/10 days > to import the user base if we were working 24/7. > > Any thoughts or ideas would be appreciated. > > Kind Regards > > > > > > Chris Latta > > Dev Ops Engineer > > Email: *chris.latta(a)dovetailgames.com <chris.latta(a)dovetailgames.com&gt;* > > Website *www.dovetailgames.com <https://urldefense. > proofpoint.com/v2/url?u=http-3A__www.dovetailgames.com_&d= > DwIBaQ&c=q3cDpHe1hF8lXU5EFjNM_A&r=N8w3J29mjdEYPeHA-d1E_ > 1Kp1KsnJ1yRhHwyWg25CWeqI66NKKjV9HfGziPFIi6m&m=_HgpMwhlqiUmJ_ > XCFFf6pca_gQTfRn_B7ffiTjA2GFo&s=VooA7E_wHEXBe3mebYeF_ > 3gLbE7D3MVKSfIhD1bkc70&e=>* > > P Please consider the environment before deciding to print this email. > > > > *This e-mail and its attachments may be confidential and are intended > solely for the use of the individual to whom it is addressed. * > > > > *Any views or opinions expressed are solely those of the author and do not > necessarily represent those of Railsimulator.com* > > > > *If you are not the intended recipient of this email and its attachments, > you must take no action based upon them, nor must you copy or show them to > anyone. * > > > > *Please contact the sender if you believe you have received this email in > error.* > > > > *Dovetail games is a trading name of RailSimulator.com LTD Registered In > England No: 6751125 * > > > > *Registered Office: Dovetail Games is a trading name of Railsimulator.com > Ltd The Observatory, Chatham Maritime, Chatham, Kent, ME4 4NT* > > > > *VAT Registration No: 948 5431 91* > > P please don't print this e-mail unless you really need to. > > _______________________________________________ > keycloak-user mailing list > keycloak-user(a)lists.jboss.org > https://urldefense.proofpoint.com/v2/url?u=https-3A__lists. > jboss.org_mailman_listinfo_keycloak-2Duser&d=DwICAg&c= > q3cDpHe1hF8lXU5EFjNM_A&r=N8w3J29mjdEYPeHA-d1E_ > 1Kp1KsnJ1yRhHwyWg25CWeqI66NKKjV9HfGziPFIi6m&m=_HgpMwhlqiUmJ_ > XCFFf6pca_gQTfRn_B7ffiTjA2GFo&s=Jfxn8u56My6lDDZf6YNhUwBS- > XMNM5T539rXphLQMaE&e= > _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user