January 14, 2025 at 6:55 am
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
January 15, 2025 at 7:06 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
January 15, 2025 at 1:19 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy