Copy Azure Tables Between Storage Accounts

Question

_{Friday, July 10, 2015 5:30 PM | 1 vote}

What is the best way to copy Azure tables from one storage account to another?

My tables are large so I don't want to download them and upload them.

I would like them to be copied in one action, if possible.

One of my tables has 18 million rows.

I tried AZCopy (preview release) without success.

Thanks in advance...

Ken

All replies (5)

_{Tuesday, July 14, 2015 3:16 AM ✅Answered}

Actually, there is no server-side copy for Azure Table, so you have to export the table and then import the exported data into another table.

AzCopy is a good tool for that:

AzCopy /Source:https://myaccount.table.core.windows.net/srcTable/ /Dest:localFolder /SourceKey:key1

AzCopy /Source:localFolder /Dest:https://myaccount.table.core.windows.net/destTable/ /DestKey:key2 /manifest:<The manifest file name shown in the output of previous command>

For further information of AzCopy, you can refer to http://aka.ms/azcopy .

If you hit any issues while using AzCopy, please feel free to contact me.

_{Friday, July 10, 2015 7:32 PM}

Thank you for your reply.

I downloaded the tool, but I do not see how it can copy an entire table to another storage account.

Can you walk me thru that?

I have downloaded Azure Storage Explorer 6 Preview (6.0.3.1)

Ken

Ken

_{Friday, July 10, 2015 9:55 PM}

Thank you again.

I will try this.

I assume the last step would be to convert from the blob back to a table using AzCopy.

I was hoping to do this in one step since my table is large.

It sounds like I need to do it in 3 steps: table to blob, blob on one storage to blob on another storage, blob to table.

Do you think I would get better thruput just writing a c# program to read from one table and write to the other?

Ken

Ken

_{Friday, November 15, 2019 3:43 PM}

Unfortunately transferring to/from tables is no longer supported in AzCopy.

_{Monday, November 18, 2019 5:28 AM}

@B Barrett I would request you please create a New thread with complete details. If you are getting any error message or error code. Please share the screen shot. May I know what exactly are you trying perform?

If you want to copy data to and from your Azure Table storage service, then install AzCopy version 7.3.