如何备份我的 Windows Azure 表存储？
我希望能够备份我的表存储，并且我需要将数据（导出和导入）从我的生产环境移动到桌面上的开发环境。
有谁知道我可以使用的任何工具或方法。
I would like to be able to back up my table storage and also I have a need to move the data (export and import) from my production to development environment on my desktop.
Does anyone know of any tools or method that I can use to this.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
您可以使用 Cerebrata 的 Azure 管理 Cmdlet 产品。它允许您下载和恢复 Azure 表存储（以及更多内容）。您可以从此处下载。
You can use Cerebrata's Azure Management Cmdlets product. It allows you to download and restore your Azure table storage (and many more things). You can download it from here.
http://clumsyleaf.com/products/tablexplorer
TableXplorer 可让您将所有表数据导出到 XML 或CSV 文件。
http://clumsyleaf.com/products/tablexplorer
TableXplorer will let you export all table data to an XML or CSV file.
正如其他人所提到的，有一些工具可以让您以各种格式下载数据，但值得注意的是，这些工具都不是像您可能习惯使用 SQL Server 那样的真正备份。
据我所知，它们都只是运行常规表存储查询来扫描表中的所有记录并保存结果。如果您拥有合理数量的数据（并且如果您正在使用表存储，那么您可能会这样做），此备份很可能需要一个小时或更长时间。
为了简单起见，假设您有两个大型相关表 A 和 B。如果备份从备份表 A 开始，然后转移到表 B，当备份完成表 B 时，它可能包含以下记录：依赖于表 A 中不存在的数据。
如果您只想刷新开发环境中的数据，这可能是完全可以接受的，但您确实需要意识到这一点。
As mentioned by others, there are tools out there that let you download your data in various formats, but it's worth noting that none of these are a true backup like you might be used to getting with SQL server.
As far as I'm aware they all just run a regular table storage query to scan through all of the records in the table and save out the results. If you have a reasonable amount of data (and if you're using table storage then you probably do) it's quite possible that this backup could take an hour or more.
For the sake of simplicity let's say you have two large related tables, A and B. If the backup starts by backing up table A, then moves on to table B, by the time it finishes backing up table B, it might contain records that rely on data in table A that's just not there.
If you just want to refresh the data in your development environment, this could be perfectly acceptable, but you do need to be aware of it.
您可以尝试此解决方案，它可以让您将表和 blob 备份/还原到相同或不同的存储帐户。
You can try this solution it lets you to backup/restore your tables and blobs to the same or different storage account.