I need to download data from windows azure table storage back to a SQL Server database inside the office network every night. There could be up to 100,000 entries in the table. What’s the most efficient way to do this (i.e. the method that costs the least)?
A:
You might be able to zip/compress it before transferring. http://social.msdn.microsoft.com/Forums/en-US/windowsazure/thread/b33d4e52-ba20-40f8-af42-d8bbdc4069ef
Sam
2010-01-29 00:03:55
+1
A:
Since you are paying for bytes out, compressing it is the first step. Then maybe put it in blob storage so that it can be picked up.
Simon Munro
2010-02-02 09:31:47
+1
A:
Yesterday I moved some code to CodePlex that can help you export entities from Azure table storage: Azure Table Query. If you choose Output to Compressed Xml the export file should be pretty small.
Jason Haley
2010-02-05 12:39:15