CODEWITHSUNDEEP
azuresharepointazure-storage
GauteR
GauteR

Reputation: 360

Azure Blob Storage: Bulk populating the storage

I have a snapshot of an image database from Access Web Online (AWO is being decommissioned in April 2018). The datasheet contains a lot of random variables and an URL to the image stored on a SharePoint server. I need to get the images stored at the URL's location stored in the Azure Blob Storage. Is it possible? If so, how would I do it? I have administrator access to all services.

I can mention that my experience on the field is lacking.

Upvotes: 0

Views: 366

Answers (1)

kim
kim

Reputation: 3421

In my opinion I would look at some way to automate this by scripting.

If scripting, I would split this problem into two parts.

  1. Get the files from SharePoint
  2. Upload the files to a blob storage

Downloading from SharePoint

When looking at getting files from SharePoint, you have a couple of alternatives, again:

  1. Use some external tool, and automate the download process, e.g. ShareGate
  2. Write some script yourself

If scripting it all yourself, I would opt for using SharePoint PnP PowerShell cmdlets.

To download a file, simply run

$siteurl = "https://{tenant}.sharepoint.com"  

#First connect to SPO
Connect-PnPOnline -Url $siteurl  

#Get the file
Get-PnPFile -ServerRelativeUrl /SPDocuments/Folder4/Files.docx -Path D:\Downloads -FileName SharePointFile.docx

Automate the retrieval process using the data you got at hand, the database. Export the paths as a .csv file and iterate over it in the script.

In this example I assume you are on SharePoint Online, but these cmdlets work for

  • SharePoint 2013
  • SharePoint 2016
  • SharePoint Online

Uploading the files to an Azure Storage Account

This part should be easier.

Here you can go the scripting route again and use:

  1. Azure PowerShell, i.e. Set-AzureStorageBlobContent for uploading
  2. Azure CLI
  3. AzCopy to upload files from the command line

or you can use the graphical tool, Azure Storage Explorer to do it using a GUI.

Note: there are other ways to connect to a Storage Account also. I just listed the easiest ones for this specific case. However, you can also access a storage account programmatically, from e.g. C# code or using FTP.

Azure Storage Explorer

Using Azure Storage Explorer you can simply select the files you downloaded earlier and "copy & paste" them to your Azure Storage Account.

Upvotes: 1

Related Questions