How to migrate a list of on premise mongo DB collections to Azure CosmosDB using ADF?

Jithin M V 96 Reputation points
2021-11-15T05:49:42.917+00:00

I know how to create the source, sink and linked service in Azure ADF and how to migrate a collection to Azure CosmosDB. In fact I have migrated few of my collections already. But the concern is, I was able to do that only by collection by collection. How can we migrate all the collections in a single go?
I have 64 collections with a lot of data. So doing it manually for each one of them is really time consuming. Is there a better way to do that. If so please help me on that. Thank you

Azure Migrate
Azure Migrate
A central hub of Azure cloud migration services and tools to discover, assess, and migrate workloads to the cloud.
717 questions
Azure Cosmos DB
Azure Cosmos DB
An Azure NoSQL database service for app development.
1,441 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,533 questions
{count} votes

Accepted answer
  1. HimanshuSinha-msft 19,376 Reputation points Microsoft Employee
    2021-11-15T23:13:04.957+00:00

    Hello @Jithin M V ,
    Thanks for the ask and using Microsoft Q&A platform .
    You will have to use

    1. A foreach loop and pass on the collection names .
    2. Inside the FE loop please place a copy activity and paramterrized the dataset .
      149525-image.png
      149513-image.png
      149514-image.png

    Please do let me know how it goes .
    Thanks
    Himanshu

    -------------------------------------------------------------------------------------------------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

0 additional answers

Sort by: Most helpful