info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



Copy files from On-Prem to Microsoft Azure Blob Storage
by BF (Principal Consultant; Architecture; Engineering)
2016-04-27







AzCopy is a Windows command-line utility for copying data to and from Microsoft Azure Blob, File & Table storage.
You will need to create a Storage account in order to start using AzCopy.
Download the latest version of AzCopy & install it.


Image #1: Microsoft Azure Storage Tools






Image #1: AzCopy.exe with sample parameters




Parameters:

/Source - Local Path in this example
/Dest - Azure Storage URI in this example
/DestKey: Access Key to Azure Storage Container
/V: Log File
If want to overwrite all with force use /y


Image #1: Log File





Image #1: Azure Portal Storage Container




Resources:

Transfer data with the AzCopy Command-Line Utility

AzCopy – Uploading/Downloading files for Windows Azure Blobs


Note:

IF using this to copy Microsoft SQL Server backup files that will be restored from URL, it will thrown the below error:
"The specified URL points to a Block Blob. Backup and Restore operations on Block Blobs are not permitted."
To workaround that issue, make sure AzCopy has /BlobType:page
or
Use SQL Server Backup to Url which creates BlobType = Page.