Want to copy data from multiple SQL Server tables to a single MongoDB collection?
Using DBToMongo, a SQL Server to MongoDB converter for Windows, MacOS, and Linux, you can transfer data from multiple SQL Server tables to 1 MongoDB collection 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.
Copy data from multiple SQL Server tables to one MongoDB collection
Login to SQL Server.
Login to MongoDB.
Click “Convert Similar Tables” at task dialog.
then show the wizard.
1. Select source SQL Server tables.
2. Choose a destination MongoDB collection and config fields.
3. Summary.
4. Copy data from SQL Server to MongoDB.
Click “View”, See MongoDB collection data.
Copy multiple SQL Server tables to one MongoDB collection in command line
Save “SQL Server to MongoDB” session, then you can:
- Copy multiple SQL Server tables to one MongoDB collection in Windows command line.
- Copy multiple SQL Server tables to one MongoDB collection in Linux command line.
- Copy multiple SQL Server tables to one MongoDB collection 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
