This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". The cookie is used to store the user consent for the cookies in the category "Analytics". These cookies ensure basic functionalities and security features of the website, anonymously. Can copy collection to another database and server.Necessary cookies are absolutely essential for the website to function properly. Specify destination database, additional parameters and click Execute. Right-click on collection1 collection in DB Explorer and select Copy 'collection1' Collection to another Database. It allows to copy one or many collections between databases and servers. Copy collection to another database tool of NoSQL Manager for MongoDBĬopy Collection to another Database is a professional feature of NoSQL Manager for MongoDB Pro. 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 a professional feature of 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 |