-1

My latest IT project has me working with MongoDB for the first time. While I have a bit (very little) experience with NoSQL, I have always mostly worked with MySQL using Workbench.

I need to migrate the data from a MySQL database into MongoDB as my employer is switching over from the former to the latter.

Can someone suggest what might be the easiest way to do that?

Thanks a bundle!

closed as too broad by Philᵀᴹ, Colin 't Hart, Md Haidar Ali Khan, hot2use, mustaccio Jul 30 '18 at 12:51

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

2

Migrating between a RDBMS and a NoSQL DB is not the easiest thing. If you can dump your data to JSON (or XML), I know that Navicat for MongoDB can import data in either of those formats.

I know that MySQL workbench can export in JSON format. You might also want to try a Navicat for MySQL. I use it and I know that it can export to either of those formats.

Navicat products aren't free, but both come with a 14 day trial. That should be plenty long enough to get the job done.

Let me know how that works for you!

Dave

  • Thanks Dave! That worked quite well. I had to run the import a couple of times to get the data formatting just right, but overall, is was a fairly easy process. I used MySQL Workbench to export and Navicat for MongoDB to import. Michael – Michael Tremblay Aug 8 '18 at 23:15
  • @MichaelTremblay - Please report back later on how MongoDB compares to MySQL. – Rick James Aug 18 '18 at 2:25
  • Hi Rick, Being a NoSQL database, MongoDB is a very different animal than MySQL. Being used to the latter, getting the hang of MongoDB has required a substantial learning curve. Having said that, I strongly believe that NoSQL is the way of the future as traditional DBMSes just haven't been able to handle the quantities of data and real-time requirements of modern applications. Fortunately, using Navicat for MongoDB has greatly facilitated the switch from MySQL to MongoDB. It has a lot of wizards and tools that make the DBA's job much easier. Michael – Michael Tremblay Oct 20 '18 at 20:06

Not the answer you're looking for? Browse other questions tagged or ask your own question.