Batch import SQL files to MongoDB collections without programming

by

Posted on by

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

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

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

Bulk import SQL to MongoDB in command line

Save “SQL to MongoDB” session, then you can:

Set scheduled tasks for bulk importing SQL to MongoDB

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.

FAQ