Move tables between different Storage accounts

Question

We would like to migrate a few tables between different Storage accounts. In essence, we will create a new Storage account, and move data from the "old" storage to the new storage. That will help us separate data, improve performance and secure certain data. Is it possible to move tables without actually fetching all data and inserting all data again into a new table (copy). I have looked at the AzCopy utility, and it seems that it does not allow that. Since some of our tables that we would like to move is huge (I would say a few billions of rows in total), the copy will take plenty of time, probably a few weeks (which of course degrades the utility for our customers).

Is there anyway somehow Microsoft can help us to re-point a table from one storage account to another?

--Carl-Fredrik

Answer 1

Have you referred to this article outlines how to use Copy Activity in Azure Data Factory to copy data to and from Azure Table storage. You can refer to the suggestion mentioned in this article.
You may also refer to Choose an Azure solution for data transfer

Hope this helps! 

Additional information: Actually, AZCopy offered as a reliable solution for data transfers, and the transfer of your data was ongoing at the time of this support request archival. Please read more about AZCopy here: https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy

Note: Don’t use Azcopy version 10 for table storage.

Export Table Storage : https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy#export-data-from-table-storage

Import Table Storage : https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy#import-data-into-table-storage

Kindly let us know if the above helps or you need further assistance on this issue. 

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

Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

Answer 2

Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know..

Answer 3

@cfneikter Is there any update on the issue?

If the suggested answer helped for your issue, do click on "Mark as Answer" and “Vote as Helpful” on the post that helps you, this can be beneficial to other community members.

Answer 4

Just checking in to see if the above answer helped. If this answers your query, do click “Mark as Answer” and Up-Vote for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know..

Answer 5

@cfneikter Is there any update on the issue?

If the suggested answer helped for your issue, do click on "Mark as Answer" and “Vote as Helpful” on the post that helps you, this can be beneficial to other community members.