[gtirloni]

I'm afraid there is no quick solution. Your app will have to write to both temporarily and make the switch, no way around adding logic to it.

Even if a multi-DB polyglot proxy/gateway exists, you'd still have to specify the relations, constraints, etc... at which point you'd better do that in your app to avoid lock-in.

Google for "mongodb to postgres downtime". I've found a few detailed articles.

[fosron]

Yeah, thats what i think too, thanks. Hoping for a miracle solution. And also i did google, and i understand that the schema will have to be provided, we can do that, but the actual data transfer is the pain point here. I tried one solution, Airbyte, locally, but its mongo support is in beta, and does not use a feature like WAL, etc.