Hello everyone,after reading that strapi will drop the support for mongo I’m trying to migrate from mongodb to postgres can someone help me how to transfer data from mongo to postgre ?
Thank you.
Forgot to mention that I have transfered the tables I need the data.
The hardest part of a migration like this is the change in ID structure, there won’t be a simple solution to this since MongoDB uses Object IDs and PG uses Integers. I would suggest you dump the data from MongoDB in a standard format like JSON and modify that to remove the ID and build a script to either directly import that into PG or send the data over the REST APIs.
Relations are another story entirely, since the relational structure between MongoDB and PG is entirely different, these relations will probably have to setup manually or some very custom script.