Migration of data between cross Tenants cosmos DB accounts

Thakkelapalli Swapna (INFOSYS LIMITED) 0 Microsoft Vendor

Hi Team,

We want to migrate data between two cosmos DB NOSQL accounts which are located in two different tenants. One cosmos DB is in "CORP Tenant"(microsoft.com) and another cosmos DB is in PME tenant. Please provide me some guidance on how to proceed and how many approaches we have for this?1. What is the best method/tool to migrate the data between cross tenants for Azure cosmos db NOSQL accounts?

Thank you for your support in advance.

Thakkelapalli Swapna (INFOSYS LIMITED) 0 Reputation points Microsoft Vendor

2024-08-29T14:55:31.7666667+00:00

Hi ShaktiSingh-MSFT,

I have tried above tool and now I can be able to migrate data from Microsoft tenant cosmos dB to PME tenant cosmos dB, I have used connection string, I am yet to try with Managed identity. Could you please suggest what are the roles I need to assign to use RBAC.

I have given "IncludeMetadataFields" property to "true" in migrationsettings.json source section. But still, I can see different values for metadata fields (_ts, _rid etc) in destination cosmos container. How can I migrate metadata with same values from source to destination.

It is taking round 24 mins to migrate 200000 records. Is there any way to increase the copy activity speed.

Thanks in advance.
Thakkelapalli Swapna (INFOSYS LIMITED) 0 Reputation points Microsoft Vendor

2024-08-29T15:19:50.4666667+00:00

Hi ShaktiSingh-MSFT,

I have tried above tool and now I can be able to migrate data from Microsoft tenant cosmos dB to PME tenant cosmos dB, I have used connection string, I am yet to try with Managed identity. Could you please suggest what are the roles I need to assign to use RBAC.

I have given "IncludeMetadataFields" property to "true" in migrationsettings.json source section. But still, I can see different values for metadata fields (_ts, _rid etc) in destination cosmos container. How can I migrate metadata with same values from source to destination.

It is taking round 24 mins to migrate 200000 records. Is there any way to increase the copy activity speed.

Thanks in advance.
ShaktiSingh-MSFT 15,301 Reputation points

2024-08-30T06:22:23.8166667+00:00

Hi Thakkelapalli Swapna (INFOSYS LIMITED) •,

Could you please confirm if you are using Azure Data Factory copy activity?
Thakkelapalli Swapna (INFOSYS LIMITED) 0 Reputation points Microsoft Vendor

2024-08-30T09:33:24.0066667+00:00

Hi,

I have used the tool you have mentioned in previous post. By using that tool I can be able to migrate 200000 records in 24 mins approximately, I just want to know, can we decrease time here, and if I make "IncludeMetadataFields" property to "true" in migrationsettings.json file, still metadata values are not copied from source to destination.
ShaktiSingh-MSFT 15,301 Reputation points

2024-09-02T04:17:43.47+00:00

@Thakkelapalli Swapna (INFOSYS LIMITED)

Kindly try to optimize by expected settings and share full details of your steps taken, result and if you face issue, please raise the same in GitHub page.

Hope this helps.

Thanks
Thakkelapalli Swapna (INFOSYS LIMITED) 0 Reputation points Microsoft Vendor

2024-09-26T04:39:50.97+00:00

Hi ShaktiSingh-MSFT,We are migrating cosmos db data between Microsoft and PME tenants. If we want to use RBAC (Role Based Access Control), what is the process, as I can not assign roles to Microsoft tenant principleId in PME tenant cosmos db. I am getting below error while assigning role.

The provided principal ID [xxxxxxx] was not found in the AAD tenant(s) [xxxxxxxxx] which are associated with the customer's subscription.

Do we have any property to specify principleId in migrationsettings.json file so that I could try multi tenant pricipleId approach, I have gone through the readme file in git repo, but I did not find any property related to principleId.
ShaktiSingh-MSFT 15,301 Reputation points

2024-09-26T05:40:51.7933333+00:00

Hi Thakkelapalli Swapna (INFOSYS LIMITED) •,

Let me check on the possibility and get back.

Thanks
Thakkelapalli Swapna (INFOSYS LIMITED) 0 Reputation points Microsoft Vendor

2024-09-27T04:44:24.0166667+00:00

Hi ShaktiSingh-MSFT,

Any update on this?

2 answers

ShaktiSingh-MSFT 15,301 Reputation points

2024-08-28T09:31:13.5+00:00

Hi Thakkelapalli Swapna (INFOSYS LIMITED) •,

Welcome to Microsoft Q&A forum.

As I understand, you want to migrate Azure Cosmos DB NoSQL API account to another account.

Please refer to https://github.com/AzureCosmosDB/data-migration-desktop-tool Azure Cosmos DB Desktop Migration tool and try and let us know if you are facing any issue.

Thanks.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
ShaktiSingh-MSFT 15,301 Reputation points

2024-09-30T05:37:15.85+00:00
Hi @Thakkelapalli Swapna (INFOSYS LIMITED) ,

We have got below reply from the internal team:

Since you are using OSS tool to do the migration, https://github.com/azurecosmosdb/data-migration-desktop-toolThis tool is community supported.

Comments:

That tool does not yet support Entra Id, An issue for that support here. There is no ETA for it.

Customers can use key-based authentication to do this.

To improve copy performance customers should ensure enough RU for both source and sink as well as co-locate the compute hosting this tool in the same region as the source and sink containers on a sufficiently sized VM.

Thanks for your patience.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Migration of data between cross Tenants cosmos DB accounts

2 answers

Your answer