5

I'm using MongoDB with mongo_mapper gem in Rails and project is big enough. Is there any way I can migrate data from Mongoid to Postgresql?

Improve this question
2
  • 1
    @apneadiving yeah i know) Commented Sep 13, 2013 at 16:53
  • Why? …just curious… Commented Sep 13, 2013 at 17:28

1 Answer 1

Reset to default
16

You should look into some of the automated migration/replication tools like MoSQL: https://stripe.com/blog/announcing-mosql

One risky strategy for this migration would be to convert your codebase to using postgres and all of your models, put your site into maintenance mode, migrate your databases, deploy the new code, and bring it back up. However, this requires significant downtime and development risk of bugs or data loss.

A safer, but much more involved strategy would be to setup automatic migration of data to a new database to sync up your databases. Then, every action in the application writes to both databases. After each transaction, you verify the data is in sync between both databases and read from Mongo. This allows you to fix errors as you find them and highlight any inconsistencies. Once you are no longer finding discrepancies, you can turn off writing to mongo and retire that database, remove the mongo models/code, and move on.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

any references on how to setup automatic migration?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.