In the last week I was working on a key project to migrate a BI platform from MySQL to MongoDB. We chose that database due to its support and scalability.
Sign Up to our Engineers Community Engine to ask questions, answer people’s questions, and connect with other people.
Login to our Engineers Community Engine to ask questions and answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
In the last week I was working on a key project to migrate a BI platform from MySQL to MongoDB. We chose that database due to its support and scalability.
Method #1: export from MySQL in a CSV format and then use the mongoimport tool. However, this does not always work well in terms of handling dates of binary data.
Method #2: script the transfer in your language of choice. Basically you write a program that reads everything from MySQL one element at a time and then inserts it into MongoDB.
Method #2 is better than #1, but it is still not adequate.
MongoDB uses collections instead of tables. MongoDB does not support joins. In every database I’ve seen, this means that your data structure in MongoDB is different from the structure in MySQL.
Because of this, there is no “universal tool” for porting SQL to MongoDB. Your data will need to be transformed before it reaches MongoDB.