how can I migrate the database dump of MongoDB into PostgreSQL?

mongodb postgresql ruby-on-rails-4 mysqldump rails-postgresql
Chitra picture Chitra · Apr 28, 2016 · Viewed 10.6k times · Source

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!

Answer

gypsyCoder picture gypsyCoder · Apr 28, 2016

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

Related questions

Querying inside Postgres JSON arrays

How would you go about searching for an element inside an array stored in a json column? (Update: Also see the 9.4 updated answer for jsonb columns.) If I have a JSON document like this, stored in a json column named …

Read More
Searching data older than a Date with typeORM

I am executing a query to Postgre DB to fetch data older than a specific date. Here's my function async filesListToDelete(): Promise<any> { return await this.fileRepository.find({ where: { last_modified: { $lt: '2018-11-15 10:41:30.746877' } }, }); } Here's how …

Read More
How to choose between MongoDB and PostgreSQL for GIS?

I'm trying to find some information on this topic but most articles I'm finding are 3+ years old. I am also fairly new to this side of things and not sure who to ask. For my particular use case, I'm not …

Read More