Is possible to migrate data from a MySQL database to MongoDB? If yes what is the right way to do that? I have this problem because i want to rewrite my PHP project in RoR.
Add a comment
|
4 Answers
Why switch the database at all? Ruby can access MySQL as well...?
Check this out: http://sequel.rubyforge.org/
2 Comments
Lukas Eder
Why the downvote? I think from the OP's question, Sequel might be a simpler option, than a complete architecture-stack-switch, as the OP didn't really clarify why they really wanted MongoDB
Bryan Migliorisi
I think its a valid answer because the OP mentions that this is a problem that he's run into because of switching languages and as Lukas points out, that is not necessarily a problem. +1
Yes, but you'll need to redesign the schema since MongoDB is a document store and not a relational database management system (RDBMS) like MySQL.
When you have decided on the MongoDB schema, you would write a simple utility in your favourite language that selects from the MySQL database, transforms the records to suit your new schema, and inserts them into your MongoDB database.
Comments
Please try my plugin.
Comments
Yes, Mysql to mongodb, it can be migrate easily, I am sharing a URL when You will get the exact work in very simple way. You Have to follow to steps.
1.Mapping database structure
2.Export the data and import it according to the defined structure.
To see more detail , follow this link https://dzone.com/articles/how-migrate-mysql-mongodb
