Users: 15,000+ | Page Views: 50,000+ | PPS: 2.5
TechDevOps.com
Explore Tools
{Experts in Microsoft SQL Server Operations, Performance, HA/DR, Data Migrations & Cloud Computing}



Copy files from On-Prem to Microsoft Azure Blob Storage
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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.