Database Reference
In-Depth Information
Figure 3.12 CloudXplorer's clean user interface.
AZCopy
As you can imagine, neither of the previous solutions is exactly what you
want when developing a production system where data movement is one of
the keys to success. A command-line tool for data movement to and from
Windows Azure storage is needed. AZCopy to the rescue. It is available
on GitHub ( https://github.com/downloads/WindowsAzure/
azure-sdk-downloads/AzCopy.zip ).
AZCopy is similar to Robocopy in functionality except that it can natively
connect to your ASV storage. Among its many features, AZCopy enables you
to copy nested directories of files, use wildcards, and is restartable, which
means thatyoucanresume acopyprocessfromwhereitleftoff.Inaddition,
AZCopy has a verbose logging mode that is essential to an enterprise-class
process.
The following example copies all the files in recursive mode from the
localdata folder to the container called newcontainer in ASV. You
would replace key with a copy of your secret key from your Azure storage
account:
AzCopy C:\localdata
https://sqlpdw.blob.core.windows.net/newcontainer/
/destkey:key /S
AZCopy can easily be wrapped in a robust program written by you or called
from a SQL Server Integration Services (SSIS) package as needed. It could
 
Search WWH ::




Custom Search