Import SQL to MongoDB collection

by

Posted on by

Want to import data from SQL file to MongoDB collection?

Try Withdata FileToMongo, a SQL to MongoDB converter for Windows, MacOS, and Linux, Import SQL to MongoDB, Easy and Fast.

Download Withdata FileToMongo Download FileToMongo

Import SQL data To MongoDB

Login to MongoDB -> Choose SQL file -> Set MongoDB collection options -> Import SQL to MongoDB

Start FileToMongo, connect to MongoDB.

Import SQL file data To MongoDB collection - connect to mongodb

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

Import SQL file data To MongoDB collection - task window

Select the “SQL” file type.

Import SQL file data To MongoDB collection - select file type

1. Open a SQL file.

Import Data From SQL File To MongoDB collection - open SQL file

The source SQL file like this:

import SQL file to MongoDB collection - source SQL file

2. Set MongoDB collection options.

Load Data From SQL File To MongoDB collection - set collection options

3. Preview data will be in MongoDB collection.

Transfer Data From SQL File To MongoDB collection - preview

4. Import SQL data to MongoDB collection.

Copy Data From SQL File To MongoDB collection - import data

After importing, you can view imported data in MongoDB collection.

Import Data From SQL File To MongoDB collection - view data

Import SQL to MongoDB in command line

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

Set scheduled tasks for 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 for “SQL to MongoDB” conversion.
  2. Set scheduled task for “SQL to MongoDB” conversion.

FAQ

More about Withdata FileToMongo – SQL to MongoDB Converter

See also: