Skip to content

Instantly share code, notes, and snippets.

@JosiahSiegel

JosiahSiegel/bcp_to_azure_file_share.ps1

Last active September 26, 2024 21:19
Show Gist options
  • Save JosiahSiegel/be0353032351f6e342eb2ec11bc425be to your computer and use it in GitHub Desktop.
Save JosiahSiegel/be0353032351f6e342eb2ec11bc425be to your computer and use it in GitHub Desktop.
Download ZIP
BCP from Azure SQL to Azure file share
Raw
bcp_to_azure_file_share.ps1
C:\WINDOWS\system32\net.exe use S: '\\mystorageaccount.file.core.windows.net\bcp-share' /u:'mystorageaccount' '<ACCESS_KEY>'
bcp dbo.mytable OUT 'S:\mytable.txt' -d mydb -U [email protected] -a 16192 -G -S 'myserver.database.windows.net' -n -h "tablock" -K ReadOnly
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment