Studio 3T makes copying MongoDB collections across databases and servers a breeze – you literally just copy and paste your collection!
1. Copy MongoDB Collection
Select the source collection you want to copy and right-click it in the connection tree. In our case, this is collection test.people on localhost. Choose “Copy Collection” from the context menu. This will mark the collection for copying.
2. Paste MongoDB Collection
Select your target database (or collection) that you want to copy your source collection to. In our example, that is database “test” on server “ADX”. Right-click your target and choose “Paste Collection” from the context menu.
3. Configure Copy & Paste of MongoDB Collections
In the Paste Collection dialog you can choose how the copying should treat (existing) document _ids (note that this usually only relevant when you decide to copy a collection into another, existing target collection). If you paste a collection into a target database that already contains a collection by the same name, the source collection will be inserted with the prefix “Copy_of_”. To finish, click “Paste Collection”, and your source collection will be copied to your target.
4. That’s It! Your MongoDB Collection Has Been Copied!
BTW: In the bottom left corner, you can always monitor the progress of your copy operation, and in case of very long-running operations, also cancel them.
Once you’re done copying collections, check out other cool Studio 3T features like the Visual Query Builder, IntelliShell, Data Compare & Sync, and of course, our What’s New section for the latest updates.
Editor’s Note: This post was originally published in February 2015 and has been updated for accuracy.