Want to copy data from SQL Server table to MongoDB collection?
Using DBToMongo, a SQL Server to MongoDB converter for Windows, MacOS, and Linux, you can transfer data from SQL Server table to 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 SQL Server data to MongoDB
Login to SQL Server and MongoDB -> Choose SQL Server table -> Set MongoDB collection -> Export SQL Server data to MongoDB
Login to SQL Server.
Login to MongoDB.
Click “Convert From Table” at task dialog.
then show the wizard.
1. Choose source SQL Server table.
2. Choose destination MongoDB collection and config fields.
3. Summary.
4. Copy SQL Server table data to MongoDB collection.
Click “View”, See MongoDB collection data.
Copy SQL Server data to MongoDB in command line
Save “SQL Server table to MongoDB” session, then you can:
- Copy data from SQL Server table to MongoDB in Windows command line.
- Copy data from SQL Server table to MongoDB in Linux command line.
- Copy data from SQL Server table to MongoDB in macOS command line.
Set scheduled tasks for coping SQL Server data to MongoDB
You can schedule and automate this “SQL Server to MongoDB” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.