Want to batch copy data from SQL Server tables to MongoDB collections?
Using DBToMongo, a SQL Server to MongoDB converter for Windows, MacOS, and Linux, you can batch copy data from SQL Server tables 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.
Batch copy data from SQL Server tables to MongoDB collections
Login to SQL Server and MongoDB -> Select SQL Server tables to copy -> Set MongoDB collections -> Copy SQL Server data to MongoDB
Login to SQL Server.
Login to MongoDB.
Click “Convert All Tables” at task dialog.
then show the wizard.
1. Select source tables.
2. Target collections, choice “Import Type”.
3. Map SQL Server tables to MongoDB collections.
4. Summary.
5. Batch copy SQL Server data to MongoDB.
Click “View”, See MongoDB collection data.
Bulk copy SQL Server tables to MongoDB collections in command line
Save “SQL Server to MongoDB” session, then you can:
- Bulk copy SQL Server tables to MongoDB collections in Windows command line.
- Bulk copy SQL Server tables to MongoDB collections in Linux command line.
- Bulk copy SQL Server tables to MongoDB collections in macOS command line.
Set scheduled tasks for coping SQL Server data to MongoDB
You can schedule and automate this converting task by:
1) Save session and create .bat file.
2) Set scheduled task for Windows.
FAQ
More about DBToMongo – SQL Server to MongoDB Converter
Download DBToMongo
