Want to export multiple MongoDB collections to 1 SQL file?
Using Withdata software MongoToFile, a MongoDB SQL exporter, you can export multiple similar MongoDB collections to a single SQL file 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.
Export multiple MongoDB collections to a single SQL file
Login to MongoDB -> Choose MongoDB collection -> Set SQL options -> Export MongoDB to SQL
Start MongoToFile, connect to MongoDB.
Click “Export Similar Collections” at task dialog.
Select “SQL” file type.
1. Select MongoDB collections to export.
2. Set SQL options.
3. Summary.
4. Export multiple MongoDB collections to one SQL file.
After exporting, you can view output SQL file.
You can schedule and automate this “MongoDB to SQL” conversion task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS) file.