locked
Copy Azure Tables Between Storage Accounts RRS feed

  • Question

  • 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

    Friday, July 10, 2015 5:30 PM

Answers

  • 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.

    Tuesday, July 14, 2015 3:16 AM

All replies

  • 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 7:32 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, July 10, 2015 9:55 PM
  • 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.

    Tuesday, July 14, 2015 3:16 AM
  • Unfortunately transferring to/from tables is no longer supported in AzCopy.
    Friday, November 15, 2019 3:43 PM
  • @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.


    Monday, November 18, 2019 5:28 AM