Batch import SQL files to MongoDB collections without programming

by

Want to batch import data from SQL files to MongoDB collections?

Using Withdata software FileToMongo, a MongoDB SQL importer, you can bulk import data from SQL files to MongoDB collections easily and fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Support all MongoDB deployment types: standalone, replica set, sharded cluster, and MongoDB Atlas.
  • Support Windows, Linux, macOS.

Download FileToMongo Download FileToMongo

Bulk import data from SQL files to MongoDB collections

Login to MongoDB -> Choose SQL files -> Set MongoDB collections. -> Import SQL files into MongoDB collections

Start FileToMongo, connect to MongoDB.

Import multiple SQL files data to 1 MongoDB collection - connect to mongodb

Click “N File To N Collection” at task dialog.

Batch Import SQL files data To MongoDB collections - task window

then show the wizard.

Select the “SQL” file type.

Batch Import SQL files data To MongoDB collections - select file type

1. Open a folder contains SQL files.

Batch Import Data From SQL Files To MongoDB collections - set SQL folder

2. Set SQL options.

Batch Import Data From SQL Files To MongoDB collections - config SQL file

3. List collesions, set “Import Type”.

Batch Load Data From SQL File To MongoDB collections - select table

4. Map files to collections.

Batch Load Data From SQL File To MongoDB collections - select table

5. Summary.

Batch Transfer Data From SQL Files To MongoDB collections - preview

6. Import SQL data to MongoDB collections.

Batch Copy Data From SQL Files To MongoDB collections - import data

After importing, you can view imported data.

Bulk Import Data From SQL Files To MongoDB collections - view data

You can schedule and automate this ” SQL to MongoDB” conversion task by:

1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.

2) Set scheduled task.


More about FileToMongo – SQL to MongoDB Converter

Download FileToMongo for 30-day free trial Download FileToMongo