Azure-storage-azcopy: Does AzureCopy v10x or v8.1 support table copy?

[deepumi]

Hi,

I would like to know how do I copy azure table storage data to on premise using azcopy latest versions (v8 or v10x). Currently I am using v73 https://docs.microsoft.com/en-us/azure/storage/common/storage-use-azcopy#azcopy-with-table-support-v73 which support table copy to local. However, I am seeing one issue that UTC column for TimeStamp is storing as different value.

What is the alternative solution?

For ex :
Azure storage explorer = 2019-01-10T15:38:48.035Z

Downloaded json file using azurecopy.exe v73

Thank you!
Deepu

[zezha-msft]

Hi @deepumi, thanks for reaching out!

AzCopy V10 does not, and probably will not, support copying table storage data. I'll let @EmmaZhu help you on the format issue with V7.3.

[deepumi]

@zezha-msft Thank you.

[EmmaZhu]

@deepumi AzCopy v8 doesn't support table transferring either. You can download AzCopy 7.1 from (
https://azcopy.azureedge.net/azcopy-7-1-0/MicrosoftAzureStorageTools.msi) for table transferring.

[deepumi]

@EmmaZhu
I'm already using AzCopy 7.1 version to download the data which I mentioned above, However, If I use this approach I will be not able to use any latest features for the newer version tool. Is there any alternative solution?.

I can think of one more solution is to use storage explorer and export to locally. But in that case I cannot automate the download processand data loading to locally.

What is the recommended approach?

Also any solution for DateTime serialization issue?

Thank you
Deepu

[AMoghrabi]

@zezha-msft Out of curiosity, why won't the v10 tool support table storage copy?

We're trying to automate the backups of blobs and table storage, the two resources we use in Azure Storage Accounts. It would be nice if we can have one tool that can do both jobs.

I appreciate your work on the tool, thanks!

[zezha-msft]

Hi @AMoghrabi, great question! +@seguler to help answer it.

To my understanding, the Table Storage is going to be part of the Cosmos DB, so I think the tools supporting CosmosDB will be adding support for Table.

[deepumi]

@zezha-msft Does CosmosDB tool currently support storage table download?

[seguler]

@wmengmsft for Table support asks

[zezha-msft]

Closing as AzCopy is most likely not the right tool for adding Table support.