Menu
I replicate the application using the database as postgresql but later on I came to know that application was using mongodb and I got the dump of the app in json format which was of mongodb.
So any help regarding to migrate the mongo db dump into postgresql will be so appreciated.
Thank you!
698
Data export with pg_dump From the PostgreSQL docs: The idea behind this dump method is to generate a file with SQL commands that, when fed back to the server, will recreate the database in the same state as it was at the time of the dump. PostgreSQL provides the utility program pg_dump for this purpose.
The Decision to Switch From NoSQL But one key feature was missing, and it made all the difference. Timing was the main reason that The Guardian switched from MongoDB to PostgreSQL — and a different choice would likely have been made today since DynamoDB recently added that missing important feature.
You can migrate MongoDB into PostgreSQL using MoSQL.
Follow the github page of MoSQL. It contains the information, how you can do the migration.
Follow the this blog post for more information
150
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
