![]() ![]() To use Duplicate Collection you can download NoSQL Manager for MongoDB Freeware or buy NoSQL Manager for MongoDB Pro.ĭuplicate Collection as a part of NoSQL Manager for MongoDB Freeware is free for non-commercial use. ![]() + Copies collection properties and indexes. Specify destination collection name, duplication parameters and click Duplicate. Right-click on collection1 collection in DB Explorer and select Duplicate 'collection1' Collection. It allows to duplicate collection very quickly within the same database. Duplicate collection tool of NoSQL Manager for MongoDBĭuplicate Collection is an internal tool of NoSQL Manager for MongoDB Freeware and NoSQL Manager for MongoDB Pro. + Can clone collection the a diffretent database and server.Ħ. Mongoimport.exe /host: /port: /db:test /collection:collection2 /file:collection1.jsonĮxecution time: 44s (27s mongoexport + 17s mongoimport) Usage - run the command in command line: mongoexport.exe /host: /port: /db:test /collection:collection1 /out:collection1.json The mongoexport and mongoimport tools are parts of the MongoDB tools package. + Can clone collection to another database and server. Mongorestore.exe -host -port -db test -collection collection2 "x:\out\test\collection1.bson"Įxecution time: 18s (9s mongodump + 9s mongorestore) Usage - run the command in command line: mongodump.exe -host -port -db test -collection collection1 -out "x:\out" You can download the tools package via MongoDB Download Center. The mongodump and mongorestore tools are parts of the MongoDB tools package. Usage - run the command in Shell: db.collection1.aggregate()ĭb.collection.aggregate() command reference 4. Can clone collection to the same server only. Usage - run the command in Shell: db.collection1.find().forEach( Doesn't copy collection properties and indexes.Ģ. Can clone collection to the same database only. Can only be run against MongoDB 4.0 or earlier versions. Usage - run the command in Shell: db.pyTo("collection2")Įxecution time: 7m 5s (tested on MongoDB 4.0 cluster) ![]() The results of our comparison you can find here. Copy collection to another database tool of NoSQL Manager for MongoDB.Duplicate collection tool of NoSQL Manager for MongoDB.Test collection collection1 contains 1 million documents with size about 500Mb. The replica set consists of three MongoDB 4.2 members. We'll test performance on replica set cluster in local network. We hope this small research will help to find the fastest way for you. We'll measure cloning time, point advantages and disadvantages, compare usability (5-point scale, higher value is better) for each way. There are several ways how to clone a collection within the same or to a different MongoDB database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |