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 query MongoDB with "like"?

I want to query something with SQL's like query: SELECT * FROM users WHERE name LIKE '%m%' How to do I achieve the same in MongoDB? I can't find an operator for like in the documentation.

Read More