Batch import SQL files to 1 MongoDB collection without programming

by

Posted on by

Want to import data from multiple SQL files into 1 MongoDB collection?

Using Withdata File To DB, a MongoDB SQL importer for Windows, MacOS, and Linux, you can import data from multiple SQL files into a single MongoDB collection in one go, 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.

Download FileToMongo Download FileToMongo

Import multiple SQL files into a single MongoDB collection

Login to MongoDB -> Choose SQL files -> Set MongoDB collection options. -> Import multiple SQL files into a single MongoDB collection

Start FileToMongo, connect to MongoDB.

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

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

Import multiple SQL files data To a single MongoDB collection - task window

Select the “SQL” file type.

Import multiple SQL files data To 1 MongoDB collection - select file type

1. Open a folder contains SQL files.

Import multiple SQL files to 1 MongoDB collection - set SQL folder

2. Set SQL options.

Import multiple SQL Files To 1 MongoDB collection - config SQL file

3. Set MongoDB collection options.

Load multiple SQL Files To 1 MongoDB collection - select table

4. Preveiw data will be in MongoDB.

Transfer multiple SQL Files To 1 MongoDB collection - preview

5. Import multiple SQL files to a single MongoDB collection.

Copy multiple SQL Files To 1 MongoDB collection - import data

After importing, you can view imported data in MongoDB.

Import multiple SQL Files To Single MongoDB Collection - view data

Import multiple SQL files to a single MongoDB collection in command line

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

Set scheduled tasks for importing multiple SQL files to a single MongoDB collection

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

More about FileToMongo – SQL to MongoDB Converter