Batch import SQL files to 1 MongoDB collection without programming

by

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

Using Withdata software FileToMongo, a MongoDB SQL importer, 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.
  • Support Windows, Linux, macOS.

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

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