Transfer data from azure vm to blob storage

  • Hi Experts

    I want to move data/ some million rows from a Azure vm table to Azure blob storage.

    What all are the best ways to complete this task?

     

    Thanks

    Manoj Bhadiyadra

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • If you create a container inside your storage account, you can then use the mount command to mount it as NFS storage inside the VM.

    Something like this (example code from online):

    $fileShareName = "<your_file_share_name>"
    $driveLetter = "Z:"
    New-PSDrive -Name $driveLetter -PSProvider FileSystem -Root "\\$storageAccountName.file.core.windows.net\$fileShareName" -Persist -Credential $ctx.StorageAccount.Credentials

    After that, however you want to export the data.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply