How to migrate all collections in one db in Azure Cosmos DB(Mongo API) to another db in Azure Cosmos DB(Mongo API)?

Question

How to migrate all collections in one db in Azure Cosmos DB(Mongo API) to another db in Azure Cosmos DB(Mongo API)?

Anoop Chandra Manduri 1

How to migrate all the collections in a db in Azure Cosmos DB API for Mongo to another db in Azure Cosmos DB API for Mongo? I have tried using Azure data factory but for that we need to create all the collections in target destination and then map each collection.

1 answer

Your answer

Answer 1

Oury Ba-MSFT 20,911 Microsoft Employee Moderator

Hi @Anoop Chandra Manduri Thank you for posting your question on Microsoft Q&A and for using Azure services.

My understanding is that you are trying to migrate all collections in one DB in Azure Cosmos DB (MongoDB API) to another db. in Azure Cosmos DB (Mongo API). Please let me know if my understanding is not correct.
To achieve that Azure Data Factory is one of the options and it is also an Azure Tool.

Cosmos DB Migration options | Microsoft Learn

Another approach will be the native mongo export and mongo import tools, as per the below reference.
Migrate MongoDB offline to Azure Cosmos DB API for MongoDB, using MongoDB native tools | Microsoft Learn

Besides the native mongo export and mongo import, and the Azure Data Factory approach, you can try Azure Database Migration Service:
Tutorial: Migrate MongoDB online to Azure Cosmos DB API for MongoDB - Azure Database Migration Service | Microsoft Learn

Please let us know if that helps.

Regards,
Oury

Oury Ba-MSFT 20,911 Reputation points Microsoft Employee Moderator

2022-05-09T17:01:39.1+00:00

@Anoop Chandra Manduri
Please let us know if the answer was helpful. Feel free to reach if need additional clarification.

Regards,
Oury
Anoop Chandra Manduri 1 Reputation point

2022-05-10T18:09:14.97+00:00
@Oury Ba-MSFT Your understanding is absolutely correct and the documents are extremely helpful.

I have 2 follow up questions,

While transferring the collections using ADF, I had to manually create the collections in the destination dataset and map the collections accordingly while copying, this is feasible for less than 5 collections in a database, but I have a database which has lot more collections. How can I copy those collections without creating collections in the destination dataset manually. In short how can I maintain the same structure which is present in source, without explicitly creating the structure in destination dataset?

When I try to use ADF to transfer collections, there is a condition that the destination dataset should not be empty. To overcome this I have created a dummy collection in the destination dataset. Is there any other way to satisfy this condition and why is it necessary?

Thank you for the suggestions

Anoop

Share via

How to migrate all collections in one db in Azure Cosmos DB(Mongo API) to another db in Azure Cosmos DB(Mongo API)?

1 answer

Your answer