Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Danny Brady 17 posts 112 karma points
    Apr 29, 2019 @ 10:43
    Danny Brady
    0

    Migrating from Azure Blob Storage back to a local file system

    I have the scenario where I need to convert an Umbraco site running it's media with Azure Blob Storage back to the regular local file storage. I have updated the FileSystemProviders.config file back to:

      <Provider alias="media" type="Umbraco.Core.IO.PhysicalFileSystem, Umbraco.Core">
        <Parameters>
          <add key="virtualRoot" value="~/media/" />
        </Parameters>
      </Provider>
    

    After this I ran a couple of SQL scripts to update the 'cmsContentXml' and ' cmsPropertyData' tables:

    update cmsContentXml 
    set xml = cast(replace(cast(xml as nvarchar(max)), 'https://bloburl/media/', '/media/') as ntext)
    go
    
    update cmsPropertyData 
    set dataNText = cast(replace(cast(dataNText as nvarchar(max)), 'https://bloburl/media/', '/media/') as ntext) 
    go 
    

    After republishing the content, I started to see the media references go back to a local reference. However, with Le Blender grid editor components, the media references are still to the blob storage...

    Is there similar SQL queries that need to be run to update Grid editor content, LeBlender content or any cache lingering somewhere? I have reset the application pool and republished content.

    Thanks,

Please Sign in or register to post replies

Write your reply to:

Draft